I need help with searching for records

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

Guest

I want my phone number field to automatically search for a record with the same phone number and pull it up. I am having trouble with it, also, I need a table that will be on the data entry page that will show what they have bought and when, so when the record comes up, so does all their past information. How do I do this? Any help would be appreciated...
 
-----Original Message-----
I want my phone number field to automatically search for
Click to expand...
a record with the same phone number and pull it up.

<snip>

Put a combo box on your form, modifying the Row Source of
the following to your field names:
SELECT [qryEmployee].[Phone] FROM [qryEmployee]

By the way, the combo box Wizard works quite well.

In the After Update event of the combo box, modify the
following code for your field names:

Private Sub cmbFind_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[Phone] = " & Me![cmbFind]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

More detail on the second question may help someone help
you.

Roxie Aho
roxiea at usinternet.com
 
Back
Top