Form question

[Secret Squirrel]

I have a label on my form that when double-clicked turns the backcolor of
that label to "vbYellow" and also makes 2 of my bound checkboxes visible.
When I close the form and then re-open it the checkboxes are no longer
visible and the backcolor of the label has returned to it's normal backcolor.
How can I keep these in the state they were when I double-clicked that
particular lablel? The label should remain yellow and the two checkboxes
should remain visible after a double-click on the label.

SS

 

[Software-Matters]

Hi,
Firstly you will need to record the action in a table i.e. if a checkbox is
checked then a corresponding record in the table will also need to be
checked. Then you need to run some code on the OnCurrent of the form. It will
be something like this:

if me!checkbox1 = Yes then
me!control = vbyellow
me!checkbow2.visible = true
else
me!control = Other colour
me!checkbow2.visible = false
end if

Obviously this is very rough and I have used generic names but you get the
idea.
--
<a
href="http://www.software-matters.co.uk/bespoke-database-design.html">Bespoke
Access Database Development</a>
<p>Software Matters</br>
Straightforward solutions that work</p>


: