I've had this Access DB for years. It's has a master table or names and a child table with attendance dates.
The form shows on the screen with a tab for the attendance form. The form sorts the dates in DES order.
I wanted to click a button and:
Add a Record
Then sort the attendance dates in ASC order so the new added record would be at the top.
move the focus to the new (empty) attenance date.
I got the add a record by entering this code inn the On Clicl property of the New Button:
StrSQL = "Insert into Attendance (IDNUM) Select IDNUM from Member where IDNUM = [Forms]![Secretary Changes]![IDNUM];"
Docmd. RunSQL StrSQL
Docmd.doMenuItem acformbar, acrecordsmenu,5 , , acmenuver70 (Refresh)
But Orderon doesn't work!!! Even if I set the focus to the Attendance form.
Any help would be greatly appreciated