Drop Down Field in Form

[bsdixon]

I have a form that has customer information and their customer number. I then have a subform that has a drop down field that lists all of the product numbers that they have previously ordered. I want to select the product number from the drop down field and then have this number automatically populated into another subform. I then enter the quanity order on this subform.

What code or macro do I need to write so that when I select a number from the drop down box it then automatically populates the field in the second subform.

Thanks for your help.

 

[bsdixon]

Can someone please help!

I cannot get the code to work so that it will populate into a new record on the second subform.

Thanks!

 

[bsdixon]

Is this possible or do I just need to better explain what I am trying to do???

Please help!!

Thanks

 

[Robert_Mc]

Hi

Can you be a little more specific about what you want to do. It's easy to get a field to inherit the value selected from a list or combo box, but it gets harder if you want multiple selections