Mar 21 2022 02:51 PM
Good day I have a table with data, and I am trying to run a query with the criteria from a combo box.
When I run the query I get no data. I don't know how to figure out what's wrong. Also I don't know how to access my post, as I posted this last week.
Thanks
Cristina
Mar 21 2022 03:35 PM
I think you can go to your profile and obtain a list of all previous posts you have made, but of all the forums I frequent, this is easily the least intuitive to navigate.
With regard to your question, asking in such generic terms makes it impossible for anyone to guess what the specific problem could be. If you were to offer specifics, such as the SQL of the query (not a screenshot of the query design grid, but the actual SQL) and some sample data that SHOULD return values, maybe someone would then be able to help identify potential reasons for the problem.
Mar 21 2022 03:44 PM
Mar 21 2022 04:13 PM
Mar 21 2022 04:20 PM
What is the rowsource for the combo box, [Forms]![Preview Reports]![Combo100]
And we try to rename controls instead of accepting the default assigned by Access, "Combo100" apparently is based on a lookup table of accident causes, so give it that name: "cboAccidentCause" or similar.
My guess is that there is probably a number field involved, and not just the text field indicated, but we have to see that as well.
Mar 21 2022 06:24 PM
Mar 22 2022 06:07 AM