I have a parameter query that I want to get a value from a single combo box on a form. In the combo box I want the values to come from a field in a table. The query returns no results when I run it. If I use a combo box that has a value list the query works fine. It doesn’t work when the combo box gets it’s values from a table. Here is the row source information from the combo box
SELECT [AllDataTBL].[ID], [AllDataTBL].[PropertyDate] FROM [AllDataTBL] ORDER BY [PropertyDate] DESC; The row source type is 'Table/Query'
Any help would be appreciated. I'm new to this. Happy to provide more information.