G Guest Nov 7, 2004 #1 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
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 Nov 7, 2004 #2 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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
