Find Feature

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a button on a form that will be used to find a record. Is there way
to set the find button i created to only look for info in a specific field
rather than looking in the field the cursor is in at the time? Any help would
be appreciated.

Thanks,
Ray
 
In the Click event of your command button, SetFocus to the field you want to
search before you activate the search, e.g.:
Me.City.SetFocus
...

If you want to search whichever field the cursor was in previously:
Screen.PreviousControl.SetFocus
 

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

Back
Top