Really Really need Help with this one!

[crann]

I want to have 2 combo box on my form.

1 where you select store number and the store name will appear in a text box

2 where you select a plu code and the plu description appears in another text box.

Have done my tables.

Have created one combo using wizards which finds the store name based on the store number i select in box one, but cant creat a second box for plu info. Always ends up being linked to the first box. Or access replies cannot find a link between the fields.


Is there any easy way for a basic beginner. Cant move on till i get this sorted.

Any simple answers really welcomed.

Thank you in advance

Jon

 

[helloworld]

how big is your database? if it is pretty small, zip it and post it...then I will get a better understanding of what you are saying

 

[ghudson]

Is the description already a field within the record source of your combo box? If so, then you just need to adjust your combo box to display that field as well.

If not, then you need to use the DLookup function in the text box. You will need to requery the text box from the AfterUpdate event of your combo box.