Text Box with Control Source DLookup

  • Thread starter Thread starter DanW
  • Start date Start date
D

DanW

My form uses a DLookUp on a Text Box Control source to
autofill based on another Text box on the same form that
is a key to an unrelated table.

When I updated the related Text Box the DLookUp doesn't
update. I have to re-open the form to get the DLookUp to
update on this record. How can I force it to update as
the related Text box is updated?
 
If the DLookup() expression includes a reference to the other text box, I
would expect it to update. If it doesn't you could cause the form to
recalculate the calculated controls like this:
Me.Recalc
 
Back
Top