Access Form Display Without New Record

Thank you for looking at my question,

I have a form pulling data directly from a table. Is it possible to not display the new record IE to only display those records from the table containing data.
Gary CroxfordOperations Support AnalystAsked:
Who is Participating?
Ryan ChongCommented:
yes, you can.

try go to the Design View of the form, then properties > Data tab: set Allow Additions to No
Gary CroxfordOperations Support AnalystAuthor Commented:
Bingo! Thank you
Anders Ebro (Microsoft MVP)Microsoft DeveloperCommented:
Should users be able to edit data? If not, then consider setting AllowEdits to false, or the dataset type to Snapshot.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I would not set the dataset type to snapshot unless you really need it.

   "snapshot" sounds fast and it is a light weight cursor in the end, but it can be expensive to execute depending on the size of the resultset.

   When you tell JET/ACE to do a snapshot, your asking it to create a copy of all the records in the resultset at a given point in time.  Few hundred records won't matter, but if it's in the tens of thousands or larger, you will notice the difference.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.