Second SubForm. 1

[lars7]

Hi,
I'm trying to get a report to open from a check box on a second subform with this code I got from:

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

docmd.OpenReport "ReportReviewLetters", acViewPreview, "", "[Pay Number]= Me!FormQuerySubStaffLookup.form!FormQuerySubStaffLookUpAssSub.form!text1 "

It looks to be ok but it's not opening the report with the criteria.

Thanks in advance.

 

[Zion7]

you're not concatenating correctly...

if your criteria is a string then,

"[Pay Number]= '" & Me!FormQuerySubStaffLookup.form!FormQuerySubStaffLookUpAssSub.form!text1 & "'"


if numeric (which payNumber probably is)

"[Pay Number]= " & Me!FormQuerySubStaffLookup.form!FormQuerySubStaffLookUpAssSub.form!text1

 

[lars7]

Hi Zion,
Pay number is a text field as the first digit is a letter.

I'm getting a message box "Access cant find the field FormQuerySubStaffLookup referred to in your expression" with this:

"[Pay Number]= '" & Me!FormQuerySubStaffLookup.form!FormQuerySubStaffLookUpAssSub.form!text1 & "'"

The form names are:

FormQueryMain: Main Form.
FormQuerySubStaffLookup: SubForm 1.
FormQuerySubStaffLookUpAssSub: SubForm 2.

 

[lars7]

Hi again,
I changed it to reference the main form.

Me.Parent.Parent!Text1

Thanks.

 

[lars7]

With quotes off course,

"[Pay Number]= '" & Me.Parent.Parent!Text1 & "'"

thanks Zion.