Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Print Status (2003)

    I have a form which displays details of quotes. The user gets the option to print the quote by means of a button, which then asks for the quote number. Is there a way of displaying on the form, that the quote being displayed has already been printed.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Print Status (2003)

    You could add a field Yes/No field named Printed to the table.
    Add a line to the On Click event procedure of the command button to set this field to True:
    <code>
    Me.Printed = True
    </code>
    Put a text box on the form with control source
    <code>
    =IIf([Printed],"Quote printed","")
    </code>
    Set the Locked property of this text box to Yes and the Enabled property to No.
    Note: do not name this text box Printed - giving it the same name as the field leads to confusion, since Printed is used in the formula in the control source.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •