Ok Having problems with combo box.
I have 2 tables: store info and Plu Info
In store info there are 2 fields: store name & store number
In Plu Info 2 fields: Plu Code & Plu Description.
I have a form to input data and search from combo boxs etc etc.
I have created 1 combo box using the wizard. When i enter a store number the store name appears. Great!
Now i want to add another combo box so when i enter or select a plu code the plu description is display.
So 2 combo boxs serahcing the form for info based i want enter but from seperate tables. is this possible???????
I cant created the 2nd box using wizard because it always seems to change the data in the first box.
Is there an easy way for beginners. No good with code yet and need it explained simply.
Hope someone can help.
Thank you in advance
Jon
I have 2 tables: store info and Plu Info
In store info there are 2 fields: store name & store number
In Plu Info 2 fields: Plu Code & Plu Description.
I have a form to input data and search from combo boxs etc etc.
I have created 1 combo box using the wizard. When i enter a store number the store name appears. Great!
Now i want to add another combo box so when i enter or select a plu code the plu description is display.
So 2 combo boxs serahcing the form for info based i want enter but from seperate tables. is this possible???????
I cant created the 2nd box using wizard because it always seems to change the data in the first box.
Is there an easy way for beginners. No good with code yet and need it explained simply.
Hope someone can help.
Thank you in advance
Jon
