I am trying to get a table we keep updated in Access database to be the dropdown contents in an excel form.
I wanted to use the Data Validation tool and select the drop down, but I cannot seem to figure out how to gain the data in my Access Table.
My Access Data base is a network file used across multiple sites. It has the most correct comprehensive list for the required data. Looking for the best way to accomplish this.
Ultimate Goal:
Form that can be populated from computer or printed and filled in.
Controlled form with specific fields left open for free range editing (Will be password protected from general users)
Inputs control saved file name
Sign-offs in specific locations will que form save.
I wanted to use the Data Validation tool and select the drop down, but I cannot seem to figure out how to gain the data in my Access Table.
My Access Data base is a network file used across multiple sites. It has the most correct comprehensive list for the required data. Looking for the best way to accomplish this.
Ultimate Goal:
Form that can be populated from computer or printed and filled in.
Controlled form with specific fields left open for free range editing (Will be password protected from general users)
Inputs control saved file name
Sign-offs in specific locations will que form save.
