Open form with filter value from Table

[tagteam]

I have a temp table that i am using to complete some tasks. I have to use it so that close my form and run an update query. Then when i open the form back up I want to go back to the record it was on when closed. I have that record id in the temp table.



in the past I have used the following
DoCmd.OpenForm FormName:="Myform", WhereCondition:="[ID]='" & Me.ID & "'"

however, the form is not open now and I need to open it based on the value in the temp table.
I have tried

DoCmd.OpenForm FormName:="Myform", WhereCondition:="[ID]='" & TempTable.ID & "'"

But that does not work

[Bulzie]

I have to use it so that close my form and run an update query.

Can you explain this part? Can you just run the update query, then requery/refresh the form without closing it?

[tagteam]

Each time I try to run the update query with the form open it fails due to lock violations so I had to close the form to get the data to update.

[tagteam]

The update query will run if i just double click on it in the navigator but if I start it up in vba from an on click action I get the lock violations. I am not sure why it will run when not cued up by vba but wont when it is in my code!

[davegri]

If there are more than one record in the temptable, you will have to specify which record to look at.
Another approach would be to store the ID in a tempvar (Tempvars!tvMyID = Me.ID.value) before closing the form.
Then
docmd.openform "MyForm",,,"ID =" & tempvars!tvMyID