combo box help

[james_halliwell]

Hi Everyone

please could someone help me with cascading combo boxes i am very new to Access and have no idea how to do this i have looked at other forums but its abit above my head

the first combo box is a drop down of account and the second is a list of products in that account but the second one list every product i need it just to show what in that account

i have attached a database if possible could some one look at it and do it so i can see what they have done all this where from select wasnt shown on my course

Many thanks

 

[jsv2002]

I've looked at your sample and to be honest your table structures need work you have no unique identification fields for your hospitals (Autonumber or similar) and no foriegn key to relate the tables. You also need form/s to input your details as entering directly into tables is never a good idea also would cut down on work when generating a record to pick from list to input info into Accounts Info table and limit the chance of user input error.

Have a look at the attached sample it should point you in the right direction and post any questions you might have.

Good luck John

 

[DCrake]

You need to take a step back and read up on normalisation, naming conventions and reserved words and characters first.

Top 10 tips

David

 

[jsv2002]

^^^^ And what DCrake said

 

[james_halliwell]

appologise this was a quick copy and paste from the original database set up with primary keys & input forms

thanks for the fast respone

 

[jsv2002]

Ok no probs the afterupdate event in the first combo box is probably what you after in the sample I posted.

Good luck

 

[gemma-the-husky]

the main concept is that the second combo box (products) is effectively filtered by the first combobox (customers), so that the second combo box shows you the products for the selected customer only.

This is achieved by basing the second combo box on a query, which uses/takes into account the setting from the first combo box.

So after you make a selection from the first combo box, you requery the second in the "afterupdate" event of the first.

effectively combobox2.requery