Continuous form problem: All the form records are affected

[accesser2003]

I have a continuous form bound to a recordset that has the following fields:

- Ignore: Boolean
- OverTime: Boolean
- AnnualLeave:Boolean
-ExtraValue: Double

The Ignore, OverTime, AnnualLeave fields are bound to a I, O, A checkboxes respectively in this continuous form. The ExtraValue bound to a EV textbox in this form.

What I want is that when the user check O or A checkboxes, the EV textbox is enabled only for this form record NOT all the form records, when the user check I checkbox, the EV textbox is disabled only for this from record, NOT all the form records.

The problem is that whenver the user check, all the form records EV text box is affected by this action.

Is there any way to achieve this?

 

[Dennisk]

in short no.

If you have any unbound control on a continious form your only have one control repeated. So change the value in one and they all change. This is the way Access works.

To get around this create a new column in the table and bind the EV txtbox to this.
or
another way to do this is to disable your continious form and create a button to open a single form for data entry then update the continious form on exit.

 

[Rich]

There's a simple work around in the example posted on this thread
http://www.access-programmers.co.uk/forums/showthread.php?t=36986