DBLookUp

[brmk]

I have a combo box and a text field. The text field has a DBLookUp as the control source. The lookup uses the value of the combo box (combo box = customer, DBlookup is for address). It works the first time that you select a customer from the combo box. But if I change the value in the combo box to a different customer, the DBLookup does not execute again.

 

[Howard Brody]

Put the LookUp in the AfterUpdate event of the ComboBox

----- brmk wrote: ----

I have a combo box and a text field. The text field has a DBLookUp as the control source. The lookup uses the value of the combo box (combo box = customer, DBlookup is for address). It works the first time that you select a customer from the combo box. But if I change the value in the combo box to a different customer, the DBLookup does not execute again.

 

[George Lob]

Use an After Update event procedure on the combo box that requeries the text
field.

Me.txtAddress.Requery

I have a combo box and a text field. The text field has a DBLookUp as the

control source. The lookup uses the value of the combo box (combo box =
customer, DBlookup is for address). It works the first time that you select
a customer from the combo box. But if I change the value in the combo box
to a different customer, the DBLookup does not execute again.

 

[brmk]

Thank You.