Combobox Dlookup Value

[nicksource]

I have a Combobox basically listing all the rows in a table, however one field is a number which corresponds to another table to get its details.

How do I make a combobox so it looks up the detail from another table using the number in this field? I can't add DLookup to a combobox or edit the SQL Query for it.

Any ideas?

 

[boblarson]

I have a Combobox basically listing all the rows in a table, however one field is a number which corresponds to another table to get its details.

How do I make a combobox so it looks up the detail from another table using the number in this field? I can't add DLookup to a combobox or edit the SQL Query for it.

Any ideas?

Why not set the rowsource of the combo box to be a query which then you can have the other table in the query as well and then, instead of the number you select the description field from the second table.

 

[nicksource]

When I do no values appear in the Combobox, it just shows as blank.

 

[boblarson]

Post the db here and we can probably help you quicker. Follow these instructions:

http://www.access-programmers.co.uk/forums/showthread.php?t=140587