I have created a query based on a table of contractors that I have. When I open up the query I get the following error:
"The Settings you entered isn't valid for this property."
I have double checked the table settings and they are all set up to be short text or number. I have check with other revision of my database and nothing has changed. Is there a way to fix this error before my users start working in it?
Also I have a side question, is it possible to make a report with a drop down list so that we can print reports out per item instead of have 20 different buttons to sort them out?
Run the compact/repair utility
Recreate the query.
If that does not work, then please post the SQL behind the query
This is really a separate/unrelated question that should be dealt with in a separate/new question, ...but yes, this is possible,
There is a combobox wizard that will help you create a combobox from the Items table (and include the ItemID).
...then you can use code like this to filter for the selected item
DoCmd.OpenReport "YourReport", acViewPreview, , "ItemID=" & Me.YourCombobox