How to make select B subquery on select A?

[Guest]

Hi,

My terminology is probably wrong but I'm working with a simple form that
lets user enter data about customer invoices (errors etc).

I have 3 tables (customer info, invoice info, invoice error log).

Now, in one field I want to enter customer Id (from "customer table") and
then I would like the second field to display a list with that particular
customer id's invoices (found in "invoice table").

So given input in "customer text box" the "invoice text box" should display
a select list of invoices (that I can pick from) that belongs to that
customer (the tables are joined).

How would I do that?

Kindly,
Mikael
Sweden

 

[Guest]

Look at this link on "Limit content of combo/list boxes"

http://www.mvps.org/access/forms/frm0028.htm

 

[Al Campagna]

Mikael,
Let's say you have just selected CustID = 152
Create a Combobox of Listbox, with a Rowsource query that delivers all
Invoices, but uses the value of CustID (on the form) to filter out all
Invoices but those associated with CustID = 152.
The CustID field criteria would be... (use your own names)
= Forms!frmYourMain!CustID

After entering CustID, Requery the Combo or List to always keep the
CustID and Combo/List in synch.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."