Combo Box on subform prompts for parameter when it shouldn't Acces

Hi -
I have a form with several subforms, each of which has a combo box whose record source is a query with a parameter supplied by a value [JobNumber] on another main form, which is used to limit the records. Suddenly, the combo box on one of the subforms prompts for the parameter, when it didn't used to. The combo boxes on the other subforms work as always without prompting. I have even copied the combo box control from one of the other subforms to the problem subform, where the problem persists. Any ideas?

Found problem - I had deleted a sub-procedure from the subform, and accidentally left "End Sub". This was causing the problem somehow!

"Michelle Ives" wrote:

Hi -
I have a form with several subforms, each of which has a combo box whose record source is a query with a parameter supplied by a value [JobNumber] on another main form, which is used to limit the records. Suddenly, the combo box on one of the subforms prompts for the parameter, when it didn't used to. The combo boxes on the other subforms work as always without prompting. I have even copied the combo box control from one of the other subforms to the problem subform, where the problem persists. Any ideas?