I have a form based on a table. When they enter an id #, a query runs deleting any records left in the table and another query appends the appropriate record from another table. The textboxes don't reflect this change unless I use the following code given to me in part by a very helpful UT member:

Me.RecordSource=""
Me.RecordSource = "temp_mpi"
Me.RecordsetClone.findfirst "[trknum] = " & Me.Text52.Value
Me.Bookmark = Me.RecordsetClone.Bookmark

This achieves the desired results (the textboxes update) but when the RecordSource is being reset the form flickers and I see #Name? in each textbox. I don't have a problem with that but I know out client will.

I have tried using Me.Refresh in place of the above code, but get the same result (textboxes not updating).

How can I refresh a form without seeing #Name? ?