Need help with macro to fill field based on another field in web app (1 Viewer)

Stacey123

New member
Local time
Today, 02:27
Joined
Mar 27, 2017
Messages
2
Hello!

I am trying to build an Access web app to use in Sharepoint. I have five tables: General Contractors, Subcontractors, Brokers, Producers and Insurance. In the Insurance table, I have several lookup fields which list the values from the other four tables. I am trying to build macros to populate other fields based on the values selected in the aforementioned lookup fields.

For example, the Producers table has fields titled "Company", "Email", and "Phone". The Insurance table has a lookup field for the value in "Company". Based on the value selected, I would like the macro to populate the corresponding "Email" and "Phone" values on the Insurance table. I would like to have this value set any time the record is updated (e.g. if the Producer Company changes).

I appreciate any help you can provide!

Thanks very much,

Stacey
 

Users who are viewing this thread

Top Bottom