Lookup Box List Box ??

[GOSLINC]

First time user out here and I thought I already posted this question but cannot see where.

I have a form I created (called Employee) that has a subform in it (called voucher) which has a subform in (called aduitee).

When I am in the auditee subform I need to indicate from a list of over 1,800 records (table called companies) who the auditor audited that month....which could be one of several from the list.

Not sure how to do this in my auditee subform....I've not worked with this before, can anyone walk me through this once?

 

[mhartman]

Hello:

One way would be to drop a combo box on your form and follow the wizard instructions.

You want to select the first item, "Lookup items in table or query" Upon completion, this should house all your items you need looked up.
Regards
Mark