Query Criteria on a subform

[RayMilhon]

I have a data entry form that has a main form and 2 subforms. The main form contains Patient demographic data one of the subforms contain claim data. There can be multiple claims per Patient. I've put a command button on the subform so that the user can print a government form for that claim. The problem is that I can't seem to get the criteria right as it keeps prompting me for the parameter.



I tried forms!frm_Data_Entry!frm_Claims!claimnumber and forms!frm_claims!claimnumber. Neither works. What am I missing?

[pbaldy]

See if this helps:

Forms Refer to Form and Subform properties and controls

Another option would be to use a wherecondition instead of criteria:

BaldyWeb wherecondition

[RayMilhon]

I guess I wasn't very clear. The government form to be printed is a report. The report has a query with the criteria = to the claim number which is on the subform. It's that criteria that is giving me an issue. It's a query for a report that uses a field on a subform for the criteria.

[pbaldy]

The second technique works for opening reports too, as noted in the link. Or you can leave it like it is and use the first link to determine the correct syntax. The form remains open, right?

[RayMilhon]

Yes it does but I found the problem and it's working now. The form was named frm_Claims which is what I was using but didn't realize that when I put it as a subform on the main form I gave it the name claims. changed that portion and it worked. Thanks for the help.

[pbaldy]

Ah yes, it has to be the name of the subform control, not the name of the form itself (though often they're the same). Glad you got it working.