Hello, I have an Access 2000 ADP connecting to a SQL backend. I want to print a report of a single record based on the value of a field called OID of type INT.
I have tried putting into the reports record source the criteria of OID
= Forms!Orders!OID
to get its Value but Access 2000 changes it to
= '[Forms]![Orders]![OID]'
and from then on it use the above as a string and not its value, and cannot change the VARCHAR to type INT. I have tried using " instead of ' but have had no luck.
HELP!
I have tried putting into the reports record source the criteria of OID
= Forms!Orders!OID
to get its Value but Access 2000 changes it to
= '[Forms]![Orders]![OID]'
and from then on it use the above as a string and not its value, and cannot change the VARCHAR to type INT. I have tried using " instead of ' but have had no luck.
HELP!
