Link subform to combo box on form

[sharontodd]

I have created a form similar to the "Customer Orders" in Northwind sample.
User selects a customer from a text box and the subform shows all their
orders. A second subform will show the details of any specific order
selected. I had it working with a straight text box (as done in the sample)
where the user pageup and down to select customer but I would like a combo
box so they can select from a drop down list. I changed the child and master
link fields to the combo box, but the Order list in the subform does not
change.

Any thoughts? Thanks

 

[Piet Linden]

I have created a form similar to the "Customer Orders" in Northwind sample.  
User selects a customer from a text box and the subform shows all their
orders.  A second subform will show the details of any specific order
selected.  I had it working with a straight text box (as done in the sample)
where the user pageup and down to select customer but I would like a combo
box so they can select from a drop down list.  I changed the child and master
link fields to the combo box, but the Order list in the subform does not
change.  

Any thoughts?  Thanks

did you try requerying the subform in the afterupdate event of the
combobox?

 

[sharontodd]

That was easy. Just placing "Requery" in the afterupdate of the combo box
did it. THANKS!!

 

[sharontodd]

Hold on. It is changing the customer name for the first order in the subform
to the customer I choose next.

The subform is locked and does not allow edits. I can't say no to edits on
the form or it won't let me pick from the dropdown list.

Thoughts?