Populate multiple fields in a form.

[Steve]

Hi,
Am using Access 2002.
I have a form I use for data entry and tracking. I would like to populate 3
fields when I select the first. Provider, phone, fax. They are in a table
with the same field names.
How can I do this?
Thanks,
Steve

 

[KLZA]

try using the focus event in the Provider field:

try this

Private Sub PROVIDER_GotFocus()
Me.Phone = "555-555-5555"
Me.FAX = "555-555-5555"
End Sub

You can use if statements depending on your provider name in order to
poulate with relative info.