Lookup wizard with more than one table keeping 3rd normal form

[laqa]

Hello, How can I use the MS Acess lookup wizard in a form to search data from a table and then search another table depending on the result of the first search? It will be used for, once I choose a customer's state I can choose the city that the customer lives between the cities from that state (they have the required foreign key to their state). I am an university professor, so I need to use 3 tables to mantain 3rd normal form, and my course does not include VB, I need to use just MS Access tools.



Thanks, Luis.

[alansidman]

Luis,
I think you are referring to Cascading Combo boxes. Have a look at this--> http://www.fontstuff.com/access/acctut10.htm

[laqa]

Luis,
I think you are referring to Cascading Combo boxes. Have a look at this--> http://www.fontstuff.com/access/acctut10.htm

Thanks a lot, but, as I posted I cannot use any code, it would have to be solved using standard MsAccess tools, like queries, combo boxes, etc. My course does not include any VB.

Thanks again, Luis.

[alansidman]

Luis;
I don't believe what you want to do is possible. I have googled cascading combo boxes for MS Access and all return with a VBA solution.
Alan

[rzw0wr]

The attached may help you.

You will need to click the refresh icon to use more than once.


Database2.zip


Dale

[June7]

Maybe put a label on the form that instructs users to click the Refresh button on the ribbon.

Also, the query is not needed. The second combobox RowSource can be:

SELECT City, State_ID FROM tblCity WHERE State_ID=[Combo0];

[rzw0wr]

The OP said no code and I thought SQL would be like code so did it with a query.

Dale

[June7]

The first combobox has an SQL statement as RowSource. So no different for the second combobox. Same result, just one less object in the db. I avoid dynamic parameterized queries when I can.

[rzw0wr]

You are correct.
Thank you for pointing that out.

Dale