After record is created, grey out field

J

John

In code, how can you field out a field after the record has been created so
the field cannot be edited anymore.

Thanks in advance,
John
 
R

RobFMS

On the form, you can do the entire form by setting the property:
..AllowEdits
In the code you would enter: Me.AllowEdits = False.

For a particular field, you would do Me.<fieldname>.Enabled = False

You can execute these pieces of code in the Form's AfterUpdate() event.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Top