detect 'record selected' event

[Guest]

I have a checkbox that, if ticked, a couple of other text-boxes are
enabled... and disabled if not ticked.

While the contents are bound to a field in my table, the enabled/disabled
property is not, therefore if I tick the box and enable the text boxes in one
record, as I move through the database, they are ALL enabled.

What I need is to place that code in the 'record selected' event, if it
existed to give the appearance that the 'enable' property are being
remembered for each record.

Is there such an event or how can i achieve this ?

 

[MacDermott]

Look at Conditional Formatting in the Help file.

 

[Guest]

That certainly works for this instance, but I was also kind of hoping to do
other things that arent related to Conditional Formatting.

Im making a membership database. If the box is ticked for a child member, it
does one thing, if its an adult, it changes a few things... the parents
button caption becomes 'next of kin', some fields are disabled (done), ...
even being able to change an entire formula hopefully. etc etc (Though not
started on formulae yet ?!?!)

Many Thanks

 

[MacDermott]

I'd suggest you rethink your design a little bit.
What Access does best is to provide single-form data entry, and data
overviews as reports.
Continous forms are a bit of a step-child of both; they can do a little of
what each does, but nothing quite as well as either of the others.

If you use a single form for data entry, you can fairly easily make it do
the kinds of things you have in mind. Then you can display your results on
a report, which can also be formatted as you describe.
You can even make a continuous form to serve as a sort of "table of
contents", with just a little data about each entry, and a button to click
to see the entire data entry form.
But I don't know of any way to make a continuous form show different
controls for different records.

HTH