If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Populate multiple fields in a form.
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 |
#2
|
|||
|
|||
Populate multiple fields in a form.
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. Steve wrote: 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 |
Thread Tools | |
Display Modes | |
|
|