invalid field name or expresstion 1

[jmnekrkt]

the following code is in two reports

If Forms![misc reports].chkSelectSection = -1 Then
Me.Filter = "unit = forms![misc reports].txtSection"
Me.FilterOn = True
Else
Me.FilterOn = False
End If

In one report, the filter allows only the selected section to print. In the other report, I receive the error

"The microsoft jet engine does not recognize 'forms![misc reports].txtSection' as a valid field name or expression".

If I manually enter the text value and turn on the filter it works. It just will not read it from the other form.

Any suggestions???

Thank you

 

[mp9]

Assuming the [misc reports] form is open at the time and that Unit takes a text value, try:

If Forms![misc reports].chkSelectSection Then Me.Filter = "unit = ' " & forms![misc reports].txtSection & "'"
Me.FilterOn = Forms![misc reports].chkSelectSection

As you can see, I've also done a little code streamlining. HTH.

http://www22.brinkster.com/accessory/

 

[jmnekrkt]

You are the best. Worked perfectly. I had to change the unit to numeric...somewhere along the series of queries, it became a number...but that was all. Took me a minute to figure out you were using the check box for the FilterOn true/false. I like it.

Thank you Thank you Thank you