|
-
Mar 28th, 2003, 10:14 AM
#1
Thread Starter
Fanatic Member
A Quick Question!!!
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
-
Mar 29th, 2003, 03:01 PM
#2
Lively Member
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...
Darrin@CB69
-----------------------------------------------
Arrogance kills brain cells
-----------------------------------------------
Private Sub Sandwich (big As Byte)
On Error GoTo Pub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|