I have a problem with using filter by form in my access db.
My db has a main form with two subforms. Everything works as it should until I use the filter by form button. My criteria are accepted on the form, the records are filtered and the correct number of records are listed in the record count on the bottom of the form.
The problem is that while the first correct record is displayed, I also get a prompt for Enter Parameter Value. If I cancel this, all is OK. If I hit the OK button, the prompt disappears only to reappear as I cycle to the next record.
Does anyone have a clue what might be happening?
My db has a main form with two subforms. Everything works as it should until I use the filter by form button. My criteria are accepted on the form, the records are filtered and the correct number of records are listed in the record count on the bottom of the form.
The problem is that while the first correct record is displayed, I also get a prompt for Enter Parameter Value. If I cancel this, all is OK. If I hit the OK button, the prompt disappears only to reappear as I cycle to the next record.
Does anyone have a clue what might be happening?