Lookup Query in Table is inconsistent...

[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

 

[John Vinson]

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.

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!