Lookup Query in Table is inconsistent...

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

Hi,

I have a database in which there's a lookup query for a
particular field. However, this query should change,
depending on the record it's in. The restriction is
actually a function of the datasheet above it, so the
restricting field that is in the query has Criteria like
this: "Parent![Account ID]."

Though, as I said, this works at times, when I reach a
record in which there is no matching Criteria, rather than
returning no options in the drop down box, it returns the
last set of returned matches it looked for (i.e. if I
click on a record with four returned results to the query,
then go to a record with none, the record with none won't
display none, but instead the same four that were
displayed from the previous record).

Is there any way to for Access to refresh its lookup so
that I can bring an accurate drop-down box for every
record? Thanks a bunch.

Peter Bryn
 
Hi,

I have a database in which there's a lookup query for a
particular field. However, this query should change,
depending on the record it's in.
Click to expand...

This is easily done in a Form. It is, to the best of my knowledge,
impossible in a table datasheet.

But that's all right, in my opinion; table datasheets should be used
ONLY for design and debugging, and as such they should show their
actual contents. The "Lookup Wizard" conceals the actual contents of
the field behind the combo boxes and is a source of endless confusion
and inefficiency.

Use a Form. And clear all your Lookups back to textboxes!
 
Back
Top