use vba to find a record on my form searching all phone fields in

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jjbra - 14 Feb 2006 05:07 GMT

Hi,
I Am Trying to search a table that has three phone fields, I want to
have the user type in one phone number and be able to select it and have
access put that record on my form.

Can you help me ?

Thanks in
Advance

Reply to this Message

John Vinson - 14 Feb 2006 05:55 GMT

>Hi,
> I Am Trying to search a table that has three phone fields, I want to
[quoted text clipped - 5 lines]
> Thanks in
>Advance

You don't really need much (or any!) VBA to do this.

Put an unbound textbox named txtFindPhone on your Form. Create a Query
based on your table. Put

[Forms]![YourFormName]![txtFindPhone]

on the Criteria line under HomePhone, WorkPhone, CellPhone (or
whatever the fields are), on three separate lines - so it will use OR
logic to find it in any one of the fields; and include all the other
fields you want to see in the query.

The one snippet of VBA would be in txtFindPhone's AfterUpdate event:

Private Sub txtFindPhone_AfterUpdate()
Me.Recordsource = "YourQueryName"
End Sub

John W. Vinson[MVP]

Reply to this Message