Conditional Locking of Form Field

[jhansmann]

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?

 

[GabrielR]

In the AfterUpdate event of the Control that defines if the field has to be enabled or not:

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

 

[jhansmann]

Thanks

Hi Gabriel,

works great!

Thanks