filter by form quandry

mohobrien

Registered User.
Local time
Today, 16:10
Joined
Dec 28, 2003
Messages
58
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?
 
It's been a while since I've gotten this, but this usually happens when something is misspelled. Like you have a bound field that has it's controlsource spelled wrong.
 
Thanks folks. You're right, I was using the source instead of the name of the control. Almost the same spelling. Now I'm all smiles!:D
 

Users who are viewing this thread

Back
Top Bottom