Enter query result in a form textbox

[Damo10]

Hi,



I have a form that the user enters a machine number in textbox "Machine number" and what I would like to do is after the machine number has been entered populate the textbox "Last" with the result of the query "LastMcCleanQ"

Can someone explain how to do this please?

Regards

[rpeare]

how you accomplish this depends entirely on the design of your form. If the textbox the user is entering the machine number is unbound but the form itself is bound to the query LastMCCleanQ then all you have to do is use an event of the 'machine number' text box (ON EXIT for example) of me.requery

[Missinglinq]

You cannot populate a Textbox with result of a Query. If you need to pull a Field from a Query (or Table) that is not in the RecordSource of the Form, the usual method is to use the DLookup Function against that Table or Query, usually pinpointing the exact value using its Criteria Clause, which is similar to the WHERE Clause in SQL.

Linq ;0)>