Form opening in datasheet view

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?

--Steve
Clip2.jpg
SteveL13Asked:
Who is Participating?
 
PatHartmanConnect With a Mentor Commented:
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.
0
 
marlind605Commented:
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.
0
 
SteveL13Author Commented:
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?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
SteveL13Author Commented:
And here is another screen shot.
Clip4.jpg
0
 
PatHartmanCommented:
I think you will have to post a database that just includes the form and the table/query it uses.
0
 
SteveL13Author Commented:
After 2nd look I did find code that was resetting it.  Thanks.
0
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.