Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtering a record from Pop-Up form to Main Form

Status
Not open for further replies.
May 5, 2000
168
US
I have unbound combo boxes on an unbound subform embedded in my main form that provide selections for filters on my (single)main form. When a selection is made from one or more of the combo boxes the click event on a "go" button triggers a pop-up (continuous)form that returns all the matches. On the pop up form the user "clicks" the record that is desired. On that "click" event I want the main form underneath to find the selected record. Would the code look something like this?

It isn't working


Private Sub Form_Click()

Dim stLinkCriteria As String

DoCmd.ApplyFilter , Me![ContactID] = Forms![frmRolEdit]![ContactID]

End Sub
[sig][/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top