[AccessD] Open Form As Datasheet

[Kostas Konstantinidis]

Hi Lambert,
Thank's for your comments

/kostas

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Heenan, Lambert
Sent: Thursday, October 6, 2016 6:24 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Open Form As Datasheet

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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com