lookup fields in my table aren't looking up in the form or query .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that's based on a query which is based on a few tables put
together. In the tables there are lookup fields. In the query and form I
have these fields, but they won't "lookup". Very frustrating. Can anyone
help?
 
In my opinion, lookup fields in tables are a waste of time unless you want
your users to directly interact with the tables, which I would never
recommend.

On your form's combobox, go to the Row Source property, click the elipsis
(...) to the right, and build your lookup values there. The combobox's
ControlSource property should be set to the field in your table/query where
you want the "looked-up" values to go.

Barry
 
The combo rowsource is just a select query statement, so anything you can do
in a select query can be done in a rowsource. If you want something to look
for a value in multiple fields, put the criteria you're searching for under
both columns in the query builder, only on different rows. This will make it
an OR condition.

Barry
 
Back
Top