Problem With Report Filter

[Guest]

When I use this code to limit my report to printing the current record on my
form
I get a sytax error for

missing operator in expression YourPrimaryKey=CurrentValue

This is the code
DoCmd.OpenReport "YourReport", acPreview
Reports![YourReport].Filter = "YourPrimaryKey = " & Me![YourPrimaryKeyControl]
Reports![YourReport].FilterOn = True

Any help would be very useful

 

[Guest]

I should also note that I have the primary key field set us a lookup box so
the text in the box in design view says unbound

 

[Guest]

It would be better to use the WhereCondition argument of the OpenReport
method. For example:

DoCmd.OpenReport "YourReport", acPreview, , "YourPrimaryKey = " &
Me!YourPrimaryKeyControl]

(If it wraps, put it back.)

HTH!

David

 

[Guest]

That brings up the exact same syntax error, could it be beacause I'm using a
lookup box so it shows as unbound
--
Dustin

It would be better to use the WhereCondition argument of the OpenReport
method. For example:

DoCmd.OpenReport "YourReport", acPreview, , "YourPrimaryKey = " &
Me!YourPrimaryKeyControl]

(If it wraps, put it back.)

HTH!

David

When I use this code to limit my report to printing the current record on my
form
I get a sytax error for

missing operator in expression YourPrimaryKey=CurrentValue

This is the code
DoCmd.OpenReport "YourReport", acPreview
Reports![YourReport].Filter = "YourPrimaryKey = " & Me![YourPrimaryKeyControl]
Reports![YourReport].FilterOn = True

Any help would be very useful

 

[Van T. Dinh]

See answer in the later thread.

Please dot NOT multiple post the same question. Most respondents here
answer questions after their full day work. Allow time for replies (at
least 24 hours) before re-posting.

Please see http://www.mvps.org/access/netiquette.htm