Solved

Form opening in datasheet view

Posted on 2014-01-22
6
545 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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
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 views 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 Access…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

705 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

20 Experts available now in Live!

Get 1:1 Help Now