combo boxes again

[mon]

Hi all u wonderful helpers, I am still struggling with
combo boxes. I have 6 different lookup tables depending
on the type of invoice/job that is being entered. At the
moment I have a different form for each (ie exactly the
same form with different table for the combo box). I know
I should be able to stipulate which table to use in the
combo box, but I don't know how. Also the tables could be
joined to make one table, but then how do I stipulate
which records show in the combo box?? Please be very
specific with your advice. I have learnt a lot in the last
few weeks,but still need basic instructions.
Thanks Monika

 

[Con Giacomini]

I suggest you base the combo box's Row Source on a query. This way you can
determine what fields are needed in order to find the record you need and
the choices can be sorted in whatever sequence you need.

Con Giacomini
(e-mail address removed)