detect 'record selected' event

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Widemonk - 17 May 2005 15:25 GMT

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 ?

Reply to this Message

MacDermott - 18 May 2005 04:07 GMT

Look at Conditional Formatting in the Help file.

> I have a checkbox that, if ticked, a couple of other text-boxes are
> enabled... and disabled if not ticked.
[quoted text clipped - 8 lines]
>
> Is there such an event or how can i achieve this ?

Reply to this Message

Widemonk - 18 May 2005 09:04 GMT

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

> Look at Conditional Formatting in the Help file.
>
[quoted text clipped - 11 lines]
> >
> > Is there such an event or how can i achieve this ?

Reply to this Message

MacDermott - 19 May 2005 02:19 GMT

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

> That certainly works for this instance, but I was also kind of hoping to do
> other things that arent related to Conditional Formatting.
[quoted text clipped - 22 lines]
> > >
> > > Is there such an event or how can i achieve this ?

Reply to this Message