Form startup variable and inert on new line

[Holmes]

Hello,

I have a couple of buttons on a form that I am havinga little trouble with.

The first button increments an integer variable which changes the colour of a box dependant upon the value. When a new record is opened I want it to be 0 which sets the colour. So on the form load event I have put Status (variable identifier) = 0.

when a new record is pulled up the box is white, should be a different colour, vbgreen, when I click on the button to increment it changes, so where should I put the declaration so that for each new record the colour is reset to the starting colour.

The other slight problme that I have is that another button inserts the time into a memo field. If I click the button again it just over writes the previous time stamp.

Is there a way to put each new click on a new line? Also I want to preced the time stamp with a a statement like the frist click was at time(). The second click was at time(). So I guess that I need to just increment a var for each click to then wrire 1st click, 2nd click etc. But how do I get the "1st click text/2nd click" text and again where do I put this variable so that it begins at 0 for each new record?

Many thanks.

B

 

[Holmes]

Sorted it out,

dependant upon the value stored in the field, that calls up various pre defined text.

 

[Holmes]

no I haven't.

So original question still remains.

how to insert the time(), into a memo field on a new line so that if I click it every 5 mins the memo box would look like:

12.00
12.05
12.10

not just overwrite the previous time.

Thanks