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

B

BillyRogers

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
 
A

Allen Browne

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.
 
Top