How to make select B subquery on select A?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mikael Lindqvist - 05 Nov 2007 12:16 GMT

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

Reply to this Message

Ofer Cohen - 05 Nov 2007 14:17 GMT

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

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

Signature

Good Luck
BS"D

> Hi,
>
[quoted text clipped - 16 lines]
> Mikael
> Sweden

Reply to this Message

Al Campagna - 05 Nov 2007 14:17 GMT

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.

Signature

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."

> Hi,
>
[quoted text clipped - 17 lines]
> Mikael
> Sweden

Reply to this Message