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? ?
Here's to alcohol...the cause of ... and solution to ... all of life's problems - - Homer J. Simpson