DLookUp behavior

[Bardia]

On Access 2003 form among several controls I have a combo box that contains
names of few credit cards. I used DLookUp in two text boxes to get the cards
numbers and expiration dates from credit cards table.
It worked well as long as this combo box was very first control on the form.
But when I added another control in its place (1st on the form) and this
combo box became second control DLookUp just stop functioning. I do not get
any error message and when I delete the first control on the form again
DLookUp works. Please advice

 

[John W. Vinson]

On Access 2003 form among several controls I have a combo box that contains
names of few credit cards. I used DLookUp in two text boxes to get the cards
numbers and expiration dates from credit cards table.
It worked well as long as this combo box was very first control on the form.
But when I added another control in its place (1st on the form) and this
combo box became second control DLookUp just stop functioning. I do not get
any error message and when I delete the first control on the form again
DLookUp works. Please advice

Correct the error in your DLookUp call or your form. For help doing so please
post the actual control sources of the textboxes, and the relevant field and
control names; we can't see them!