[AccessD] Open Form As Datasheet

[Heenan, Lambert]

Glad you got that sorted out. :-)

BTW I personally always use 

Me.Dirty = False 

to commit any record changes in a bound form rather than the somewhat arcane DoCmd code

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

If for no other reason than that it is version independent. 

Lambert 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas Konstantinidis
Sent: Thursday, October 06, 2016 9:10 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Open Form As Datasheet

    DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria

That make the difference 

Thank's Paul

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Hartland via AccessD
Sent: Thursday, October 6, 2016 3:56 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Cc: Paul Hartland <paul.hartland at googlemail.com>
Subject: Re: [AccessD] Open Form As Datasheet

hmmm, what happens if you remove the stLinkCriteria and just try the line DoCmd.OpenForm stDocName, acFormDS