Automonous Field Protection

[smjohns]

Hi,

I am trying to create a screen, where data entered into fields will affect other fields on the screen. Specifically, I want to set up a field that if the user enter's a specific code, this will protect a couple of following fields following it, or enable them if the code is changed to something else. I also want to be able to default data into fields, based on entered data aswell.

Is this possible? and how?

Thanks for any help you can provide

Regards

Simon

 

[dcx693]

You can use the After Update event of your fields to trigger something in other fields. Use code something like this:

If Me.control1= [i]some value[/i] Then
    Me.control2.Enabled=False
Else
    'other stuff
End If

Be sure also to place the same code into the form's On Current event if you're using the form to browse from record to record. That way, the code will run every time you move to another record.