Dlookup Problems

liza_adam

New member
Local time
Today, 05:41
Joined
Dec 9, 2002
Messages
6
I have many fields in my table main and it’s:
AWB number
Cust_name text
Mobile text
Cite text
------------------------------------------
Cust_address text
Status text

So when I enter the AWB number all the data in other fields must appear for this particular AWB. And the user can’t change the data in the first 3 fields so I used an Unbound fields for that, but he can do that for the cust_address and status. So I just used Dlookup function but when I order the AWB number another time the data in cust_address, status will be deleted so how can I managed that.

My code is in the attachment file.

Thank you very much.
 

Users who are viewing this thread

Back
Top Bottom