Z
Zanstemic
The program has a primary form with account information and a subform with a
list of scheduled appointments.
Using the DoMenuItem method seems to limit me to the primary form.
How would you recommend approaching have a search across a primary form and
sub form?
I'm new to access and VB so a recommendation regarding the initial
architecture will help.
Here is the event procedure I'm using currently:
Private Sub Find_Record_Button_Click()
On Error GoTo Err_Find_Record_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_Find_Record_Click:
Exit Sub
Err_Find_Record_Click:
MsgBox Err.Description
Resume Exit_Find_Record_Click
End Sub
list of scheduled appointments.
Using the DoMenuItem method seems to limit me to the primary form.
How would you recommend approaching have a search across a primary form and
sub form?
I'm new to access and VB so a recommendation regarding the initial
architecture will help.
Here is the event procedure I'm using currently:
Private Sub Find_Record_Button_Click()
On Error GoTo Err_Find_Record_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_Find_Record_Click:
Exit Sub
Err_Find_Record_Click:
MsgBox Err.Description
Resume Exit_Find_Record_Click
End Sub