Pls help me with Cascading Combo boxes (1 Viewer)

Dear all,

I'm an access beginner, and I have created an admin tool for my wife who is self employed and it is working well.

I try to make the tool a bit more sophisticated by adding filtering using 'cascading combo boxes'. Unfortunately the instructions I have found so far don't seem to work... fully (I must be doing something wrong).

- Please find attached my zip.

1. tblPriceCategory = defines price categories (cheap, affordable, expensive, super expensive).

2. tblCustomers = defines Customer names related to above price categories.

3. tblObjects = defines Objects + price, related to price category.
Each price category has Objects X, Y, Z, but with different price range.


frmAssignment =>
Combo box 1: cboCustomer selects the Customer name.

Combo box 2: cboObjects should show only 3 Objects (X,Y,Z) of the price range of the selected Customer in cboCustomer.

The output of Combo box 2 is wrong, JACK gets the prices of JOEY, and e.g. RACHEL does not show any prices at all.....

I expect I do something very wrong in the query criteria.:banghead:

I hope somebody is able to help me pls.
Thank you in advance.

Kind regards,
Vernon

check out the query.

Paul has a guide for future understanding here http://www.baldyweb.com/CascadingCombo.htm

Dear Arnelgp and Minty,

Thank you sooooo much for helping me out. All works as should and you made us very happy.


'Join queries' was the simple answer and the missing link in my ratio.

Thank you for fixing this in such a very short notice. It was really bugging me that I couldn't get it right... not even after spending many evenings googling , reading and testing with the cascading combo boxes

I'll quickly close this topic.
Again thank you!

Kind regards,
Vernon