enable cells in only one column and disable other colums in a continoud form

[sanal]

Is there any way to enable the cells in only one column and to disable all other cells in a continous form , by a command button.

 

[theDBguy]

Hi. You might try something like:

Me.ColumnName.Enabled = False

 

[arnelgp]

select all the textbox/combos and set it's Enable property to No.
select the texbox you want to Enable.
on it's GotFocus() and LostFocus() Event:

Private Sub textboxName_GotFocus()
Me.textboxName.Enabled = True
End Sub

Private Sub textboxName_LostFocus()
Me.textboxName.Enabled = False
End Sub