I have a form that shows information about members in a club. I want to add a button to the form that when pushed executes a macro that reads a non-form based table that holds information about upcoming meetings. The macro would then update a field on the form to show the retrieved data from the non-form DB table.
The issue I appear to be having is that the macro, when executed from the form button, doesn’t have context for the non-form table. Can I explicitly bind the macro SQL statement to the external DB table.
For example… Form is bound to the Members Table and can access it’s fields. A second table exists call Meeting, that hold info on future (and past) meetings. When the use clicks the “Attend Next Meeting” button the macro determines what meeting is available to the member (based on some of the fields in the Members table) by reading the external Meetings table, and retrieving the next meeting type and date, then stores that data into the Members table.
Can this be done in a Base form macro?