Any suggestions with this??
I am loading a form with an ado database (an Access database). This is a view only form. If the user wants to edit a field, he is actually opening another form, with an ado connection to the database. He edits, updates, then closes the form.
The problem happens when returning to the original form. On return to the main form, I am requerying the database and reloading the txt fields. Sometimes it updates, sometimes it doesnt. I have checked the database, the changes are in the database, but the requery doesnt seem to be picking them up.