Data Validation using excel spreadsheet (1 Viewer)

[DavidCantor]

How can I validate data using an excel spreadsheet?
i have a table with Product information, I want only the ProductId that are in the spreadsheet to be used in the database. How can I check the ProductID entered in the form actually exists in the excel spreadsheet?

 

[Pat Hartman]

Link to the spreadsheet. Then use a combo on your form that has a RowSource from the linked table. Set the LimitToList property to yes.