Built in search change

  • Thread starter mlthomas007 via AccessMonster.com
  • Start date
M

mlthomas007 via AccessMonster.com

Hi,

We have a search built in to our current access database. It searches on
last name and the client would like it to search on FamilyID as well.

We have a query and a form. There is also code.
Find Existing Subject Code

Option Compare Database

Private Sub FamID_Click()
Private Sub FamInd_Click()
End Sub

Thanks. Any help added the numeric ability to our search is appreciated.
 
S

Steve Sanford

Hi Brian,

Unfortunately, no one can help with what you provided.

What is the name of your form? what is the names of the controls on the form
that have the last name and the FamilyID?

Please post the SQL of the query.
Please post the VBA for the two Subs.

If some one enters both last name and the FamilyID, which one should be the
searched?

HTH
 
Top