filtering lookup boxes

[jtidwell]

I have a lookup box that pulls up different contract numbers (Contractnum).
With those different contract numbers, I have a lookup box that pulls up the
different invoices with that number (Workordernum). My problem is I want to
only see the invoices for that certain contract number. Right now
(Workordernum) pulls up all the invoice numbers for the (contractnum) I
select.

 

[Jeanette Cunningham]

Hi,
this kind of thing is called 'cascading combos' or 'cascading comboboxes' or
similar.
If you want to have a go at it yourself, do a search on either of those
terms, there are usually plenty of examples around, often with a sample to
download. I would start with Rogers Access Library which has heaps of
samples to download.

Jeanette Cunningham