Link Access query to Excel Combo Box

[wtrimble]

I have a linked table in Access to Excel and I need to limit the input in a cell in Excel by what's listed in a query in Access. This is for data validation and integrity. The user would select a "Sample Number" in Excel that another user has put in the Access database before hand. Is there a way to do this?? Am I in the wrong forum?? haha

Thanks for any help

 

[Thomko]

This requires Excel VBA using ADO (at least as far as I know). Here how I would do it.

1) Connect to Access from Excel: Check help on Connection.Open
2) Read the data from Access: Check help on Recordset.Open
3) Write data to a (hidden) Excel sheet and define a named range containing all the data
4) Use field validation pointing to the named range to create a combo box with the list of numbers

HTH
Thomas