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
Me.cSelDate.Enabled = True
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.