How to go to a Record after enter ph# in text box and pressing ent

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

Guest

I have a form based on a query that pulls customer information. I would like
the users to be able to type a phone number in the phone number text box ,
hit ENTER and have the form go to that record.

Right now they have to click filter by form, type in the number and then
click filter.

I want then to be able to just type in the number and hit enter to go to a
specific record.
I don't know what code is needed to do this.

Thanks,
Billy
 
Use the AfterUpdate event procedure of the text box to FindFirst in the
RecordsetClone of the form.

There's an example in this page:
http://allenbrowne.com/ser-03.html
Although the example uses a combo, the process is exactly the same for a
text box.
 
You must log in or register to reply here.

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

Similar Threads

Need combo box to refresh when moving to new record 2017 1
Filter records based on user input 13
Enter value and open form to that record 3
Entering a multiple number of records based on a quantity in text box 1
Using Text Box to Enter Criteria 3
go to specific record in form 2
Combo Box to select a record and populate fields in a form 2
Prevent Full String Selection after Change Event on Control 1

Back
Top