Referring to Form Controls in theServerfilter property

[Steve]

I posted this a couple of weeks ago, but noone seems to
have replied. Can I therefore assume that this does not
work in Access 2000. If so, does it work in 2003 or other?
Do I need to look at StarOffice maybe?

I am working in an Access 2000 adp file, and trying to
create a parametrised series of reports (not rocket
science you would think).

I have a report which tries to set the ServerFilter
property to refer to values set by the user in a Form.

The Report has a recordsource called SJGVIEW3 which has
been defined against a SQL database (no problem there, the
connection / view works fine).

The form named SJGVIEWWIZ3 comprises of two combo boxes
named cmbAttribute and cmbRegionID. When I set the
ServerFilter property on the report to the following

(SJGVIEW3.AttributeID = ([Forms]![SJGVIEWWIZ3].
[cmbAttribute])) and (SJGVIEW3.RegionID = ([Forms]!
[SJGVIEWWIZ3].[cmbRegion]))

Access complains about
Line1 incorrect syntax near !
, but what is incorrect about this, can anyone tell me
please.
Debugging for the values of the form's combo boxes in
immediate mode shows that they are properly populated when
the form SJGVIEWWIZ3 is open and values selected.

HELP!!!!!!!!!!!!

 

[sid]

Have you tried:

Forms]![SJGVIEWWIZ3]![cmbAttribute]

( ! instead of . )

 

[Guest]

Sid,

Thanks for your reply, I was beginning to think I was
being purposely ignored.

Unfortunately I did try every permutation I could think
of, including your suggestion.

All seem to give the same error, when I try to preview the
report with the form open. When I try to open the report
from a button on the form, I get

There was a problem accessing a property or method of the
OLE object.

No doubt you will have seen this most useful (NOT) error
message. Why we cannot be told which property or which
method of which OLE object I have no idea. Surely this
cannot be rocket science either! Maybe I am just too
nitpicky these days or NOT.

Regards

-----Original Message-----
Have you tried:

Forms]![SJGVIEWWIZ3]![cmbAttribute]

( ! instead of . )

-----Original Message-----
I posted this a couple of weeks ago, but noone seems to
have replied. Can I therefore assume that this does not
work in Access 2000. If so, does it work in 2003 or other?
Do I need to look at StarOffice maybe?

I am working in an Access 2000 adp file, and trying to
create a parametrised series of reports (not rocket
science you would think).

I have a report which tries to set the ServerFilter
property to refer to values set by the user in a Form.

The Report has a recordsource called SJGVIEW3 which has
been defined against a SQL database (no problem there, the
connection / view works fine).

The form named SJGVIEWWIZ3 comprises of two combo boxes
named cmbAttribute and cmbRegionID. When I set the
ServerFilter property on the report to the following

(SJGVIEW3.AttributeID = ([Forms]![SJGVIEWWIZ3].
[cmbAttribute])) and (SJGVIEW3.RegionID = ([Forms]!
[SJGVIEWWIZ3].[cmbRegion]))

Access complains about
Line1 incorrect syntax near !
, but what is incorrect about this, can anyone tell me
please.
Debugging for the values of the form's combo boxes in
immediate mode shows that they are properly populated when
the form SJGVIEWWIZ3 is open and values selected.

HELP!!!!!!!!!!!!

.

.