I am a little confused as to why this keeps happening, but every time I close my database and the reopen it, the combo boxes on my form don't work.
Here are a couple of things to know. This form opens when the database opens. The combo boxes are used to filter other forms and reports, so I have some code that filters based on the selection and click of a button.
Here is what I have going on:
Form name: Open
Combo Box: Position
Where as condition for filter: [Primary Pos]=[Forms]![Open]![Position]
Query name: Top 10
Primary Pos criteria: [Forms]![Open]![Position]
Report name: Top 10
Filter: [Primary Pos]=[Forms]![Open]![Position]
Filter on Load: Yes
Once reopened and I select a Position and then hit the command button, I get a Enter Parameter message box that says: Forms!Open!Position with a blank white input box.
The only thing I have been able to do to fix the issue is to keep changing everything from Position to Positions. Overall, I am completely blank when it comes to finding a permanent solution.
Any help would be great. Thanks