DBLookUp

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Use an After Update event procedure on the combo box that requeries the text
field.

Me.txtAddress.Requery


brmk said:
I have a combo box and a text field. The text field has a DBLookUp as the
Click to expand...
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.
 
Back
Top