Enter Parameter value error

[Gismo]

Hi All, Please help.
I have a main form where I select certain values from a drop down box.
Then when I open another form, it must be filtered to the values selected on the main form.
On the second form, I have a few sub form. when I open them individually and run the query, within each form, I get the required results.
When opening the other form, it gives me a popup to enter values, enter parameter value, even thou it has been selected on the main form.
I have re linked the reference to main form, also I have compact and repaired the DB.
Any suggestions?

 

[June7]

Need to examine db. If you want to provide for analysis, follow instructions at bottom of my post.

 

[JHB]

..
On the second form, I have a few sub form.

Have you linked them together with the "Link Master Fields" and the "Link Child Fields" property?

 

[theDBguy]

Sounds like the parameter prompts are looking for something like Forms!FormName.ControlName. If so, you may have to adjust them a bit to add the subform names like Forms!MainformName.SubformName.Form!ControlName.

 

[Gismo]

Hi,
I make regular backups of my DB, I opened a copy I made a week ago and it works fine.
a day before I posted this question, it was working fine, I did not make any changes in this section. What could be the cause for this error now? it can not be a parent / child link error if it was working fine before, so that one is rule out.

Forms!FormName.ControlName should be fine as it worked before, not so?