[AccessD] Open Form As Datasheet

[Paul Hartland]

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