Search bar in form

[panyd]

Hey, I'm trying to add a search bar to a form which is linked to multiple tables. I've got it so that it will go to some records but not all of them when you select them. Anyone have any ideas?

Code:

Private Sub Combo89_AfterUpdate()
    'Moves to Customer Name text box and
    'finds the record of whatever name is selected in the combo box
    DoCmd.ShowAllRecords
    Me![Merchant Name].SetFocus
    DoCmd.FindRecord Me!Combo89
    'Set value of combo box equal to an empty string
    Me!Combo89.Value = ""
End Sub

 

[jdraw]

Try http://www.datapigtechnologies.com/flashfiles/searchform.html