Solved

Form opening in datasheet view

Posted on 2014-01-22
6
553 Views
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?

--Steve
Clip2.jpg
0
Comment
Question by:SteveL13
  • 3
  • 2
6 Comments
 

Expert Comment

by:marlind605
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.
0
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 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.
0
 

Author Comment

by:SteveL13
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?
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:SteveL13
ID: 39800572
And here is another screen shot.
Clip4.jpg
0
 
LVL 34

Expert Comment

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

Author Closing Comment

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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

932 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now