I have a Form displaying a single table (Table1), a record at a time (data-entry type form).
The standard record navigation buttons at the foot of the Form are active/working.
On the form I also have a button that runs a macro query against Table1
When the button is pressed, the macro query runs fine.
However, after the query is run, the linkage from the Form to Table1 seems to be broken and I’m no longer able to navigate through the table using the record navigation buttons. What happens is the record counter in the navigation bar changes to reflect the movement/navigation button pressed, BUT the form contents do not refresh/update.
What code do I need in the macro, after the Table1 query code, in order refresh the Form contents in accordance with the record navigation buttons, ie next record/prev record etc… ?