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


New member
Mar 27, 2017

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,


Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom