Hi all, i have just started using access i have little knowledge of it so far but have had help from google setting up. The one thing i have been un able to solve is as follows:
I have a form that called "Front screen" it uses the "serial No#" of an instrument to search for previous data. Now i would like to be able to fill in the rest of the data and save back to that record. So i have a few unbound txt boxes that use DLookUp to search for the previous data using the "Serial No#" txt box as a point of reference. The other boxes are bound to the instrument Database table.
The reason for this is that the data that uses the DlookUp is entered when the instrument comes in and the bound data on the "Front Screen" is entered at a later date.
Firstly does this make sense, secondly is this possible, thirdly can anyone help me.
Thanks in advance
I have a form that called "Front screen" it uses the "serial No#" of an instrument to search for previous data. Now i would like to be able to fill in the rest of the data and save back to that record. So i have a few unbound txt boxes that use DLookUp to search for the previous data using the "Serial No#" txt box as a point of reference. The other boxes are bound to the instrument Database table.
The reason for this is that the data that uses the DlookUp is entered when the instrument comes in and the bound data on the "Front Screen" is entered at a later date.
Firstly does this make sense, secondly is this possible, thirdly can anyone help me.
Thanks in advance
Attachments
Last edited: