Access form looses focus

Question

Please bare with me.  I am very new a this.  I have created a form providing entries to a table.  I have created an embedded event macro on the lost focus event.  It creates a TempVar that is used with another TempVar from earlier in the form as parameters in a query.  The result of the query is put into a TempVar then put into a form control using Set Property.  I use Close window to close the query.  When done instead of stepping to the next control focus seems to be thrown to the Navigation Pane.  When I click or touch the form focus returns to the next control where it should be.  What have I missed, done wrong or messed up?

Answer 1

Since a query can return multiple columns and records, you can't set a TempVar to a query. What you CAN do is ensure the query returns only one column and one record, then use a DLookup to set the value of the Tempvar

Answer 2

Answered my own question.  Many thanks to Scott and Daniel.

Answer 3

So to get the result of a query; into a tempvar I only need to set the tempvar equal to the query field?

Answer 4

To run a query there is no need to open it. So in that case, the query window would never gain focus and it would stay in the form. Once the Query object gets focus it ends the code running on the form.

Answer 5

I think we're going to need to see a copy of the database or at the very least the code/macros involved.