If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Editing Records
How can I secure only certain fields of previously entered records on a form
from being edited, while still allowing the other fields to be edited and still be able to add new records? I have used the General Ledger Account Template for Access 2003 as a foundation for my database. I have a form that is made of controls that draw from two separate tables. The form is intended for users to enter new records with content required for every field except three checkboxes. I want to prevent the user from being able to edit any of the required fields for previously entered records but allow them to edit the checkboxes at will. |
#2
|
|||
|
|||
Editing Records
You can use the 'locked' property of a control to prevent it from being edited.
"Ron" wrote: How can I secure only certain fields of previously entered records on a form from being edited, while still allowing the other fields to be edited and still be able to add new records? I have used the General Ledger Account Template for Access 2003 as a foundation for my database. I have a form that is made of controls that draw from two separate tables. The form is intended for users to enter new records with content required for every field except three checkboxes. I want to prevent the user from being able to edit any of the required fields for previously entered records but allow them to edit the checkboxes at will. |
#3
|
|||
|
|||
Editing Records
I tried that. It does prevent editing, but it also prevents me from being
able to enter anything in that control field for new records. "PJones" wrote: You can use the 'locked' property of a control to prevent it from being edited. "Ron" wrote: How can I secure only certain fields of previously entered records on a form from being edited, while still allowing the other fields to be edited and still be able to add new records? I have used the General Ledger Account Template for Access 2003 as a foundation for my database. I have a form that is made of controls that draw from two separate tables. The form is intended for users to enter new records with content required for every field except three checkboxes. I want to prevent the user from being able to edit any of the required fields for previously entered records but allow them to edit the checkboxes at will. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problems editing records in subform | reeve13 | Using Forms | 3 | November 21st, 2005 02:17 AM |
Allow new record entry but restrict editing of existing records in form controls | Tom via AccessMonster.com | Using Forms | 3 | September 13th, 2005 01:23 AM |
Appending ONLY new records to a table | Ofer | Running & Setting Up Queries | 0 | April 27th, 2005 11:13 PM |
count number of records | Joe_Access | General Discussion | 1 | January 13th, 2005 06:27 PM |
Attn Sprinks- Not duplicate insert records | babs | Using Forms | 1 | December 13th, 2004 06:25 PM |