Re: query not going as planned

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

it's still requiring me to go through the blank records, to get to the
results...
is the fact that it's a subform causing this perhaps?

i realize i may have just nailed the coffin shut forgetting that
information...

"John Vinson" wrote:

> On Mon, 25 Jul 2005 10:25:03 -0700, justin_vasko
> <justinvasko@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >this is the SQL view of my query
> >
> >
> >SELECT records.ID, records.EntryDate, records.ExpiryDate,
> >records.CaseWorkerFirstName, records.CaseWorkerLastName, records.CaseRemarks
> >FROM records
> >WHERE (((records.ID)=[txtID].[value]))
> >ORDER BY records.ID DESC;
>
> Try changing the WHERE clause to
>
> WHERE ((([Records].[ID]) = [Forms]![NameOfYourForm]![txtID]))
>
> I don't have ANY idea why what you have should work at all, much less
> why it's bringing up blank records!
>
> John W. Vinson[MVP]
>
.

Relevant Pages

  • NAVL claims?
    ... requiring a claim. ... Has anyone else had trouble contacting her majesty? ... Prev by Date: ...
    (rec.games.pinball)
  • Re: IE question
    ... my ie has started requiring me to type the http:// ... > have to close the group which shuts down explorer. ... Prev by Date: ...
    (microsoft.public.windowsxp.general)
  • Security
    ... requiring the use of a one time password to unlock it. ... Also I would like to find a way to prevent them from installing this ... Mike ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: USCG has gone Nanny-State on Me
    ... DOD Bases have been requiring this for about 10 years get with the program ... Coasty ... Prev by Date: ...
    (rec.motorcycles.harley)
  • Re: Hardware needed to run CPM
    ... Don't forget OS/8, requiring 8kw. ... Roger Ivie ... Prev by Date: ...
    (comp.os.cpm)