Enabling Controls on a Continuous Form

[adammoo1984 via AccessMonster.com]

Hi Guys,

I have a continuous form which I use for adding multiple tasks to an Action
Tracking database. In this form depending on what is selected from the combo
box depends on what controls are enabled or locked. However as it is a
continuous form these settings are placed against the same controls for the
next record and so on.

Is there any way in which you can have the settings only applied to the
individual record of the continuous form?

Ta,
Adam.

 

[Douglas J. Steele]

While it may look as though you've got, say, 50 instances of a specific
control on the continuous form, in actual fact you've got the same control
repeated 50 times. That means that any changes you make to it applies to all
instances of it.

If you put the logic to control the locking and enabling in the form's
Current event, though, at least it will be correct for the current row,
which is the only one on which you can operate.

 

[adammoo1984 via AccessMonster.com]

Doug,

I tried putting the enabling under the OnCurrent and it seems to work fine
for my needs, it flickers a bit despite turning off the echo but it works ok.

Ta,
Adam