Check box Troubles

[Guest]

I'm having trouble on a form i have designed which shows booked events for
single clients and allows new events to be entered.
On the form several check boxes are used for things such as whether the
client has paid or not etc.
I have writen some code which enables or disables these checkboxes depending
on certain criteria.
The problem is that when the code needs to enable the check box of 1 record,
that same check box is enabled for all of the records on the form.
please help if you can!
(if the code is needed, will happily provide)

 

[Guest]

Sounds as though you have coded against the 'On Open' or 'On Load' events of
the form. I would suggest moving the code to the 'On Current' event of the
form.

'The Current event occurs when the focus moves to a record, making it the
current record, or when the form is refreshed or requeried.'

Hope this helps.

 

[Ron2005]

An alternative, if the criteria is simple enough is to use conditional
formating for the checkboxes.

 

[SusanV]

If this is a continuous form, you aren't going to be able to enable /
disable the checkbox for individual records...

 

[Ron2005]

I believe that you can still disable it, but that it will NOT be grayed
out as a normal type of field would.

As an alternative it that doesn't work quite as you want you can also
toggle the locked property the same was as the enabled. This will at
least make it so they can only change those that you want to allow the
changes to.

Ron