Label Change Colour

[highburycottage]

hi,

Win XP
Access 2002 SP3

I have tried my best but cannot seem to get this to work.

I have a label that has two colours - the default colour of a normal button and red. The value is linked to a text field called invoice which has two values Yes or No.

What is suppose to happen is when an invoice is raised the label (raised) is clicked, the invoice is generated and sent by email as an attachment. The invoice value in the table is then given the value of Yes and the label turns to red.

When i close the form and reopen it - it is still red - GOOD. But when I open up a new form (via the switchboard) the label is still red. I have created a before update event (just as a test) and it resets the colour of the label to what I want it to be. But when I put it in a load or an open event the invoice value is taking the value of the first record in the database - which is Yes, and not the default value.

can anybody point me in the right direction on how to reset this label on a new record so that it is taking the value of its own record and not the first record in the table.

Thanks in advance

 

[pbaldy]

You haven't posted the code, but offhand I would use the current event to use the current record's values.

 

[highburycottage]

Paul,

Thanks thats it......been driving me nuts that has. Thanks very much.

 

[pbaldy]

No problem, and welcome to the site by the way!