Results 1 to 2 of 2

Thread: A Quick Question!!!

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Apr 2001
    Location
    New York
    Posts
    679

    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

  2. #2
    Lively Member cargobay69's Avatar
    Join Date
    Nov 2001
    Location
    Kessel Prison Camp
    Posts
    97
    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
  •  



Click Here to Expand Forum to Full Width