A
access wiz
I am completely stumped, I have searched the community on how to get this
accomplished and have yet to find the answer. I have 83 records, I have
prepared a report which is unique to each individual record, I do now want to
print out 83 records at a time, I simply want to print record 53 or 62 or 71.
I have created a command button on my form which prints out records, I have
attempted to input such code as:
DoCmd.OpenReport "YourReport", acPreview
Reports![YourReport].Filter = "YourPrimaryKey = " & Me![YourPrimaryKeyControl]
Reports![YourReport].FilterOn = True
or
me.Refresh
docmd.OpenReport "myReprot",acViewPreview,,"id = " & me!id
and it opens the print preview screen starting with record/ID 1, when it
should be displaying record/ID 42 or 71, etc... The key for both the report
and form is the ID. How do I go about printing a report 52 for form 52?
Thanks
accomplished and have yet to find the answer. I have 83 records, I have
prepared a report which is unique to each individual record, I do now want to
print out 83 records at a time, I simply want to print record 53 or 62 or 71.
I have created a command button on my form which prints out records, I have
attempted to input such code as:
DoCmd.OpenReport "YourReport", acPreview
Reports![YourReport].Filter = "YourPrimaryKey = " & Me![YourPrimaryKeyControl]
Reports![YourReport].FilterOn = True
or
me.Refresh
docmd.OpenReport "myReprot",acViewPreview,,"id = " & me!id
and it opens the print preview screen starting with record/ID 1, when it
should be displaying record/ID 42 or 71, etc... The key for both the report
and form is the ID. How do I go about printing a report 52 for form 52?
Thanks