Updating Text Box Display

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hopefully, this is an easy question.

I have a text box in a form that displays the results of a select query. The
query is based on a table that will be updated after the form is open. When
the form opens initially, the text box displays the correct result, however
if I rebuild the table that contains the query result, the text box then
display #Name?. If I close the form and then reopen it, the new, correct
value is displayed.

How can I get the text-box results to update everytime the table is modified
without having to close and re-open the form?

Thanks
 
Back
Top