filtering lookup boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jtidwell - 30 Dec 2007 02:59 GMT

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.

Reply to this Message

Jeanette Cunningham - 30 Dec 2007 03:28 GMT

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

>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
[quoted text clipped - 4 lines]
> (Workordernum) pulls up all the invoice numbers for the (contractnum) I
> select.

Reply to this Message