[AccessD] Open Form As Datasheet

[Kostas Konstantinidis]

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