Populate multiple fields in a form.

  • Thread starter Thread starter Steve
  • Start date Start date
S

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