Returning Value from a Query to a Form text field

[kathorton]

Hello I am new to Access, and I am wondering if I making this harder than it needs to be.

First, I am using Access 2007. Second, I am using two tables, Inventory and Service Request. Inventory is a list all the Inventory, with has things like location (building & room number), type (desktop, laptop, etc.) and access tag number. Service Request also has Access Tag Number (should link back to Inventory) & date of reported/resolved problem and description of problem/solution.

On my form for Service Request, I have the access tag number as a fill text box, when you double click on that text box, it runs a Query that asks for the 1) Building, 2) Room Number & 3) Type . . . Query currently opens in a the spread sheet view that shows those three things but also the Access Tag Number associated to them.

I would like that Access Tag Number to just return into the field that was double click to start the query.

Is this possible? If so what am I missing?

Thanks for any help you can give.

 

[missinglinq]

You cannot return the result of a Query into a Textbox on a Form. Instead, you'll need to use the DLookup() Function against the Query to pull the value into the Control.

Linq ;0)>