How do to an onLoad or onDisplay for detail of a form

[Paul Simpson]

Hi,

I am developing an application which will be used for logging detentions for
a school.

I have a table for students, one for offences and then one for actual
detentions (this is so that if , for example, a student misses a detention,
it can be re-set and a record is there!)

Ok, so I have a form which shows the detail of the "offence" and has a
sub-form which is a list of the detention(s) for that offence. A detention
has a date and a time (which can be 1, 2 or 3 representing break, lunch or
after school). This time is displayed as an option group (radio buttons).

What I need to be able to do is to disable certain radio buttons if a
stuednt already has a detention on a certain day (or disable all of them
until a date is set). I can set an onClick for the buttons to dis-allow a
click if the conditions are not met, but what I'd really like to do is
disable / lock buttons as each record (detail) of the sub-form loads.

Can this be done?

TIA

Paul

 

[ruralguy via AccessMonster.com]

Is your SubForm in continuous or single form mode?

 

[Paul Simpson]

Continuous

Is your SubForm in continuous or single form mode?

 

[ruralguy via AccessMonster.com]

A continuous form is really one form displayed many times and as such each
control needs to be bound to a field in the underlying query/table for it to
behave differently than any of the other records. If conditional formatting
won't get it for you (and I don't believe disabling an option group is one of
the choices) then I'm afraid you have found one of the limits of continuous
forms. In single form mode you could have taken advantage of the current
event but in continuous mode that only affects the current record.

Continuous

Is your SubForm in continuous or single form mode?

[quoted text clipped - 23 lines]