Use query result ID, Query ONLY returns one record

[Kryst51]

I have a query, this query pulls its information from a form and returns ONLY one record (which is what I want it to do), This record is then displayed in a listbox (listbox is based on the query) because it looks nice, on the form and verifies that a record has been found, I want to use the ID from this query and assign it as an fk in another table. I can't figure out how to get that value.... Now I could "select" the record in the list box, and that works, but I don't want to have to select the record, as there is only one option. Is there a way to do this?

 

[boblarson]

I can't see any other option unless you just use a hidden text box with a Dlookup to the query as the control source and then you can refer to the text box value.

 

[Kryst51]

I can't see any other option unless you just use a hidden text box with a Dlookup to the query as the control source and then you can refer to the text box value.

Great Idea! I'll try it! Thanks!

 

[Kryst51]

Hey Bob,

The DLookup worked wonderfully, Thank you!

 

[boblarson]

Hey Bob,

The DLookup worked wonderfully, Thank you!

Cool, glad we could help.