Results 1 to 2 of 2

Thread: Continous form

  1. #1
    Join Date
    Apr 2002
    Location
    Thailand
    Posts
    81

    Unanswered: Continous form

    I want my Sales Order control to change color whenever a sale has been set to "completed" in a click box.

    No problem, normally, just set a form current event like this:

    If Me.COMPLETED_TRANSACTION = True Then
    Me.SO_NUMBER.BackColor = 8421504

    ElseIf Me.COMPLETED_TRANSACTION = False Then
    Me.SO_NUMBER.BackColor = 16777215
    End If

    But now I am using a continous form and this means that if the first record has the clickbox checked all records SO controls will be grey and if not all controls will be white. The form current wont update between the records in a continous form.

    How should I do? I have tried some other events but cant get it right. Can I set the Me argument to be valid only for the current record or is there an event that will do the trick?

    Jo´

  2. #2
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    228
    You can do this with conditional formatting. It's pretty limited but it should do the trick in your case.

Posting Permissions

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