Printable View
THIS MAY SOUND LIKE A STUPID QUESTION, BUT FOR THE LIFE OF ME I CAN NOT REMEMBER HOW TO DO IT....
I AM WORKING ON AN ACCESS 97 DATABASE. I NEED TO ACCESS THE PROPERTIES OF A CONTROL WITHIN A REPORT FROM THE FORM OF THE DATABASE.
I WANT TO USE A IF THEN ELSE STATEMENT TO PERFORM AN ACTION WITH IN THE REPORT WHEN A CONDITION WITHIN THE FORM IS TRUE....
CAN SOMEONE PLEASE HELP ME OUT WITH THIS ONE....THANK YOU :D
I could be wrong, but I don't think you can, exactly. Typically, I would just use a global variable, set the value in the form, then access it in the report's Report_Open procedure (or whatever the default load procedure is). And if you want to be tricky, use a table to hold the values and access the table from the report, or even bind the report's controls to the table. Sorry I can't elaborate more, I don't have any working examples on this computer and I'm a little short on time.
Hope that helps...