Form opening in datasheet view

Posted on 2014-01-22
Medium Priority
Last Modified: 2014-01-23
I have a form opening in datasheet view via a command button on a form:

DoCmd.OpenForm "frmShipments", acFormDS, , , acFormEdit, acWindowNormal

But when the form opens I see the attached at the bottom of the form... (see attachment).

But I don't want the form to display this since it looks like a new record and I have the form properties set to not allow additions.

Is there a way to not show this apparent new record?

Question by:SteveL13
  • 3
  • 2

Expert Comment

ID: 39800509
My first suggestion would be to create your own form and hide the navigation buttons. I have done this in the past and it allows you more flexibility.
LVL 41

Accepted Solution

PatHartman earned 2000 total points
ID: 39800515
Setting the AllowAdditions property to No hides the new record line so I'm not sure what you are seeing.  You've cropped the picture too tightly.  Verify the AllowAdditions property again and make sure you don't have any code that is resetting it.

Author Comment

ID: 39800565
I do have the AllowAdditions property set to No.

And I can't find any code that would be doing this.

However, I do have three DLookup field on the form.  Could that be doing it?
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.


Author Comment

ID: 39800572
And here is another screen shot.
LVL 41

Expert Comment

ID: 39800804
I think you will have to post a database that just includes the form and the table/query it uses.

Author Closing Comment

ID: 39804907
After 2nd look I did find code that was resetting it.  Thanks.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question