Hi Robert ----
>How do I set up an ADD button procedure so it knows that when I change the
Active Page in a Page Frame, it knows to add a record to that particular table in the active page. For example I have 4 pages called Student, Parent, Emergency, and Grades. If I click on the Student Page, when I click on the ADD button I want it to only add to the Student Table.
>
Assuming the Add button is in the main form (?) In the Click() method of the Add button, do the following:
DO CASE
CASE THISFORM.pgfWhatever.ActivePage = 1 && Students???
SELECT student
INSERT INTO student
THISFORM.pgfWhatever.pgStudent.SetFocus()
CASE ... && for other pages.
ENDCASE
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05