Hi

I have 2 controls one is cEndMonth and the other cSelDate. If the cEndMonth="Y" then i want the cSelDate control disabled.

I put this on the "single" form on the lostfocus of cEndMonth and it works;

If cEndMonth = "Y" Then
Me.cSelDate.Enabled = False
Else
Me.cSelDate.Enabled = True
End If

However if i try the same code on the continuous form it disables all the controls in the cSelDate column if the cEndMonth is "Y" and re-enables the hole column if it is "N"

How can i do it so only the current line that i am on's cSelDate is disabled or can that not be done? any ideas will be appreciated.

Mark

Hello:

That is the normal behavior for controls to operate on a continuous form. In design view there is only one row of controls. When you disable a control in a continuous form it disables the whole column when run.

Regards

Mark

That is what i thought. Is there any way around this. Dont want them to edit the one if the other is "Y"

Any ideas?

Mark