I have a database with a calibration form for water quality meters. Every 8 weeks a new meter is calibrated and sent to the end user. An email is auto generated to inform the end user that a new meter is on its way.
The email contains the Serial No of the new meter and asks the end user to return the previous one for calibration. Each end user appears many times in the database.
I need to insert into the email the serial no for the previous meter that the end user had as each user may have more than one meter.
Fields contained on the Form are:- END USER NAME, meter serial number split into two Fields OWNER and NWQIS, and a DEPLOYMENT DATE.
I have tried Queries, but cannot get the
field data ( serial number ) out of the query.
I was thinking maybe have a textbox on the form that when the end user is selected it fills in the textbox with the previous serial number.
Or maybe there is a way with VBA.
Any ideas would be appreciated.
The email contains the Serial No of the new meter and asks the end user to return the previous one for calibration. Each end user appears many times in the database.
I need to insert into the email the serial no for the previous meter that the end user had as each user may have more than one meter.
Fields contained on the Form are:- END USER NAME, meter serial number split into two Fields OWNER and NWQIS, and a DEPLOYMENT DATE.
I have tried Queries, but cannot get the
field data ( serial number ) out of the query.
I was thinking maybe have a textbox on the form that when the end user is selected it fills in the textbox with the previous serial number.
Or maybe there is a way with VBA.
Any ideas would be appreciated.