Yes, that is correct, if possible
Can you provide a link so I can upload the Excel workbook, to explain/show what I am looking for?
I have uploaded file ID 926644, which is the Excel workbook, I have also uploaded a screen shot of the list within the Access Database (file ID 419984).
When looking at the excel worksheet, on the left side, there are several labels, I am specifically working with cell G50, the label to the left of that cell says "Frame Color". I currently am using a list of cells, with a data validation tool to create the list, but due to the inventory always changing, I would prefer to use the updated list within the Access database. We update the list within the database, daily, and so if I added a new color within the database, I would have to go in and change the data validation within excel, as well, and see that as being very time sensitive.
So currently the user clicks the G50 cell, and the drop down arrow appears with the partial list I have inserted in the cells. If possible, instead of the data coming from within the cells, when the user clicks the G50 cell, it is pulling the data from the access database instead?
Is that any clearer, or did I make it muddier?
"But then, why not make the form itself within Access?"
I consider myself very average on the capabilities of Excel, and very below average on Access. What I have been able to creat within access has been very crude, but functional.
thank you though for the response.