Create a Combo Box on the form based on the "lookup table" and bound
to the lookup field.
Note that it is NOT necessary to use the "lookup field" type in your
Table to do this; it makes it a mouseclick easier maybe, but the
lookup field type has LOTS of disadvantages. See http://www.mvps.org/access/lookupfields.htm for a critique.
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.