Conditional Locking of Form Field

  • Thread starter Thread starter jhansmann
  • Start date Start date
J

jhansmann

Guest
I am developing a simple database in Access 97, where users have to enter values manually into a form. There is one field called product. Depending on that entry, either field language or country would have to be blocked to avoid invalid entries.
Do you have any ideas on how to approach that problem?
 
In the AfterUpdate event of the Control that defines if the field has to be enabled or not:


Code:
If Me.Field = "Value" Then
Me.YourField.Enabled = True
Else
Me.YourField.Enabled = False
End If
 
Thanks

Hi Gabriel,

works great!

Thanks
 

Users who are viewing this thread

Back
Top Bottom