Set Default Value on Form to Query Result

[Glacil]

The pertinent table records transfers of assets from employee to employee, and assets are often transfered more than once.

How do I set the default setting of a forms control so that when a serial number is entered, the last Location and Employee Number (that the asset was formerly transfered to) appears in the relevent (transfered from) boxes on the new transfer record?

I have a query that isolates the last location of the asset in a single record (linked as a button on the form), but am unclear on how to update the information from the query as default values on the form. When I set the default value of the form to "=[qryCurrent]![EmployeeNum]", all I get #Name? to display.

 

[PHV]

Take a look at the DLookUp function:
=DLookUp("EmployeeNum", "qryCurrent")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Glacil]

Perfect, that was exactly what I was looking for PHV. Many thanks!