Enabling Controls on a Continuous Form "adammoo1984 via AccessMonster.com" <u47484[ at ]uwe> 11/27/2008 12:24:13 PM 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. -- Message posted via http://www.accessmonster.com

Re: Enabling Controls on a Continuous Form "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_gmail.com> 11/27/2008 1:11:44 PM 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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "adammoo1984 via AccessMonster.com" <u47484[ at ]uwe> wrote in message news:8dd05406b0cc3[ at ]uwe... [Quoted Text] > 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. > > -- > Message posted via http://www.accessmonster.com >

Re: Enabling Controls on a Continuous Form "adammoo1984 via AccessMonster.com" <u47484[ at ]uwe> 11/27/2008 1:25:14 PM 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1