Disabling text boxes

[Guest_imported]

I have got four text boxes on my form displaying data from an Access table. I was wondering if there was a way I could disable these four text boxes depending on the user? I have a field in the table which determines if they should be enabled/disabled but how can I get the boxes to be enabled based on this value from the table?

 

[ghubbell]

Hi Mr HP,
In visual basic in your forms "On current" event you'd add something like:

Me.AnotherField.SetFocus
If Me.NameOfKeyField = Whatever Then
Me.Text1.Enabled = False
Else
Me.Text1.Enabled = True
End if

If you need "deeper" help with this write back... Also make sure "AnotherField" is one that would not be disabled. That's it! Gord
ghubbell@total.net

 

[Guest_imported]

Hi Gord,

Many thanks for the tip.
I have already got a macro running on the On Current event, but I put the code you gave me within the On Load Event Procedure on my form instead and it works fine!

Thanks a lot, you saved me loads of time!

Cheers,
Hanish.