[AccessD] Open Form As Datasheet

[Bill Benson]

what happens to Me.Dirty when you hit Escape and the old value in a field
reappears?

On Thu, Oct 6, 2016 at 11:23 AM, Heenan, Lambert <Lambert.Heenan at aig.com>
wrote:

> 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
>