Subform asks for parameter

[ikzouhetnietweten]

Im having a normal form called AA which works with the Preview button. But once I put that form in a subform (form1) and I click on the preview button there its asking me for a parameter value.. how can I make the form work in the subform? Thanks!

 

[pbaldy]

The syntax to refer to it changes when it's a subform:

http://www.mvps.org/access/forms/frm0031.htm

 

[ikzouhetnietweten]

okay so I tried to put in the criteria in the query: [Forms]![Form1]![AA]![POnr]
Works now, tnx

 

[ikzouhetnietweten]

But now I have a problem with the navigation form.. (kind of a subform in a subform)
When I click on the preview button in the 'Navigation Form', it doesnt work.

The criteria at the moment is:
[Forms]![Navigation Form]![AA]![POnr]

I tried [Forms]![Navigation Form]![Nav sub PO]![AA]![POnr]
but doesnt work. It has to be something with the Nav sub PO as that form is inside the Navigation Form.

 

[pbaldy]

Personally I'd simplify it by taking the criteria out of the query and using this method:

http://www.baldyweb.com/wherecondition.htm

Then you just use Me.Whatever.

 

[ikzouhetnietweten]

Got it with the builder

Forms![Navigation Form]![NavigationSubform].Form![NavigationSubform].Form![POnr]

Thanks for the help!

 

[pbaldy]

Glad you got it sorted.