Search Box

[libraccess]

I have had this code working on a form as a search box
Private Sub SearchBox_AfterUpdate()
Me.Requery
End Sub

Private Sub btnClear_Click()
Me.SearchBox.Value = ""
Me.Requery
End Sub
and the forms ID criteria
Like [Forms]![frmAddEmployee].[SearchBox]


all usual stuff
but I am trying to consolidate my forms into one form with tabs,
I have placed frmEmployee into one tabbed page (not in a Master Child arrangement)
now when opening the form a parameter query appears asking for the SearchBox
I thought maybe I could have a modal form open from a search button in the form
but the code
DoCmd.OpenForm "frmEmployee", , , "FieldName = #" & Me.cboSearch & "#"
opens a second copy of the form (at the right record)(but not in the tabbed page of course)
any clues on modifying this to update the form with the selected record

[DarrenUD]

Hi libraccess, I am not an expert but you can try this for your forms ID criteria [Forms]![Your Main Form Name]![frmAddEmployee].[From].[Controls]![SearchBox]

[libraccess]

No it seems like any criteria in this arrangement is called on when openinig the main form . thanks anyway