I have a Form in an A2K db related to Written Correspondence logging, tracking, and reporting. I need to activate certain fields based on the selection of the term "Complaint" or "Inquiry" from a combobox value list. "Complaint" needs to lock out "Inquiry" fields, and vice versa. Is there a way to lock out unnecessary fields based on this selection process? Any suggestions or assistance would be gratefully received.
Activate Form section by combo box selection
- Thread starter cft
- Start date
jfgambit
Kinetic Card Dealer
- Local time
- Today, 16:28
- Joined
- Jul 18, 2002
- Messages
- 798
On the After Update Event of your Combobox add the following for each field you want locked
me.nameoffield.locked = TRUE
Or if you want to make them invisible
me.nameoffield.visible = FALSE
Remeber to reset the fields back to their original state when you move to a new record. You can do this by adding the following to the On Current Event of the form:
Dim frm As Form
Dim ctl As Control
Set frm = Screen.ActiveForm
For Each ctl In frm.Controls
Select Case ctl.ControlType
Case acTextBox
ctl.Locked = False
End Select
Next ctl
HTH
me.nameoffield.locked = TRUE
Or if you want to make them invisible
me.nameoffield.visible = FALSE
Remeber to reset the fields back to their original state when you move to a new record. You can do this by adding the following to the On Current Event of the form:
Dim frm As Form
Dim ctl As Control
Set frm = Screen.ActiveForm
For Each ctl In frm.Controls
Select Case ctl.ControlType
Case acTextBox
ctl.Locked = False
End Select
Next ctl
HTH
Similar threads
