G
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
Coud you set these properties for your form?
Allow Edits No
Allow Additions Yes
Allow Edits No
Allow Additions Yes
A
Arvin Meyer [MVP]
Open the property sheet in the form's design view.
Go to the Data tab.
Set Allow Edits to No
Make sure Allow Additions is set to Yes
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
Go to the Data tab.
Set Allow Edits to No
Make sure Allow Additions is set to Yes
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
G
Guest
Can this be given spefically for various fields. I do not want the user to
update only certain fields.
update only certain fields.
A
Arvin Meyer [MVP]
No, the doesn't allow editing for the entire form, except on new records. If
you want to disable or lock (or both) only certain specific fields do it
like this:
http://www.datastrat.com/Code/LockIt.txt
Put that code in a standard module and call it from the Current event of
your form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
you want to disable or lock (or both) only certain specific fields do it
like this:
http://www.datastrat.com/Code/LockIt.txt
Put that code in a standard module and call it from the Current event of
your form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access