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

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?
 
G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top