Does anybody know how to pass a variable from one form to another. On the first form I am at a specific record number. Then I need to enter child table data, I use a push button to open a data entry form for the child table.
When I go to my child table form it defaults to the end.
I'd like to pass the record number of the first form to the second form and clear the entry fields to accept new data of a "one to many" relationship without the user having to remember which record number they were on and manually enter it.
When I go to my child table form it defaults to the end.
I'd like to pass the record number of the first form to the second form and clear the entry fields to accept new data of a "one to many" relationship without the user having to remember which record number they were on and manually enter it.