Form Combo Box

[Access_help_rob]

Form Combo Box help please

Hey, i have some fields in tables called Order number, stock code, due date and Notes. Now in my form i have made a combo box to select the Order number, but i then want to display in a combo box all the stock codes underneath just that order, at the moment i can select the order in the combo box, but when i go to select a stock code it displays all the stocks codes in the table and i just want the ones which are on that order, please help thanks
rob

 

[namliam]

Search for "Cascading combobox" and you will find your solution

 

[Access_help_rob]

I have looked under cascading combo boxes and i find other question with answers hich say try searching for cascading combo boxes can somebody not just tell me please how i set it up thanks rob

 

[Rich]

If you search a little longer you will find examples posted here that you can download and learn from

 

[Access_help_rob]

Hey thanks for the replies but the files didnt work i have access 97
sorry if anyone has some other files or places to look id be extremely gratefull
rob

 

[Rich]

Hey Rich,

You like the Matrix?

Have you seen the Meatrix?

The Grandchildren will enjoy that

 

[Rich]

Hey thanks for the replies but the files didnt work i have access 97
sorry if anyone has some other files or places to look id be extremely gratefull
rob

Download the Solutions example db from the Microsoft Knowledge base, it's a 97ver db with many useful examples including the one you're looking for

 

[Mile-O]

I think this'll be on my next FAQ thread.

 

[Access_help_rob]

Microsoft example database didnt help either sorry as its combo boxes relate to 2 sepearte tables when all my data is in one table
please advise thanks
rob

 

[Mile-O]

Microsoft example database didnt help either sorry as its combo boxes relate to 2 sepearte tables when all my data is in one table

That's why it's called "Solutions" - your data is not normalised; it should be in two tables.

 

[Access_help_rob]

ok heres another dilema in my combo box now i now have it that it displays order number stock code and order date all from one combo box now when i select other stockcodes other than the first one on the oder the only date displayed on the form is the first stocked code item on the order any idea?
thanks
rob