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.
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.