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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top