combo boxes again

M

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
 
C

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
[email protected]
 
Top