[AccessD] Open Form As Datasheet

[Paul Hartland]

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

On 6 October 2016 at 13:48, Kostas Konstantinidis <kost36 at otenet.gr> wrote:

> I tried also acnormal and  acdatash with no luck
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Paul Hartland via AccessD
> Sent: Thursday, October 6, 2016 2:53 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
>
> one of the comma's can't remember which off-hand should be a datamode and I
> think you can specify how you want the form to open there, I had problems
> in
> the past where the default mode wouldn't open correctly when using
> docmd.openform unless I also specified it in the docmd line
>
> On 6 October 2016 at 12:27, Kostas Konstantinidis <kost36 at otenet.gr>
> wrote:
>
> > Hi all,
> > It works but although the "OffersData" is by default open as datasheet
> > it opens as single form
> >
> >     Dim stDocName As String
> >     Dim stLinkCriteria As String
> >     DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ,
> acMenuVer70
> >     stDocName = "OffersData"
> >     stLinkCriteria = "[CustomerId]=" & Me![Id]
> >
> >     DoCmd.OpenForm stDocName, , , stLinkCriteria
> >
> >
> > Could you please help?
> >
> > Thank's
> > /kostas
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
>
> --
> Paul Hartland
> paul.hartland at googlemail.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com