C
clayton ledford
I have a form that i added the following code to a button. It allowed me to
print a Report, but only for the one record showing in the form on the click
event:
DoCmd.OpenReport "YourReport", acPreview
Reports![YourReport].Filter = "YourPrimaryKey = " & Me![YourPrimaryKeyControl]
Reports![YourReport].FilterOn = True
It was working perfectly, but a query that i'm running now required me to
change my primary key in my table to Text instead of Number. My form still
updates information properly, but the print button gives me the data type
missmatch error 3464.
Which portion needs updated? Form, report, code? Other?
print a Report, but only for the one record showing in the form on the click
event:
DoCmd.OpenReport "YourReport", acPreview
Reports![YourReport].Filter = "YourPrimaryKey = " & Me![YourPrimaryKeyControl]
Reports![YourReport].FilterOn = True
It was working perfectly, but a query that i'm running now required me to
change my primary key in my table to Text instead of Number. My form still
updates information properly, but the print button gives me the data type
missmatch error 3464.
Which portion needs updated? Form, report, code? Other?