Securing Data

crimzonclover

New Member
Joined
Dec 15, 2005
Messages
5
I'm new at this whole access form stuff, I have some knowledge about making basic forms and such.

I'm trying to make a form that inputs into a single table. What I want to happen is the user has the ability to add a new record, save it, and then once its saved.. not be able to edit it again or delete it. Also to be able to search for a specific record without editing it. Though there will be someone who maintains it who needs the ability to edit & delete.

Help please!!!
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

AgentSmith

Well-known Member
Joined
Mar 8, 2004
Messages
575
I'm sure there are options in the form's properties that cover this. Unfortunately I don't have Access on this PC, but if you go into the form's "design" view then you should be able to right-click on the form and bring up the properties window. Somewhere in those properties will be things like "Allow Additions", "Allow Editing", etc.

Does this help?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,762
Messages
5,574,091
Members
412,567
Latest member
mm1
Top