Search in subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The find function is allowing me to search in the primary table "Attendees"
but does not search across records in the subform "AttendeeSubform". How do I
create a search within the subform fields to bring up an attendee record?

Any suggestions
 
This is very helpful. Since I'm new to access, I'd like to make sure I'm
approaching the problem using the best architecture. The search is
conditional where the user can search on the "Name" and can narrow the search
by Age. This can be in one search or successive searches.

For discussion, how much customization can be done to the DoMenuItem Method?
Or do I need to create a custom form that performs this search.

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
 
Back
Top