Prev: API HELP
Next: access 2007 read-only
From: NevilleT on 3 Jul 2008 01:38
I have a form and subform which I want to view as a datasheet for quick
scanning purposes, Once I find the record I want, I double click a field
which runs
DoCmd.RunCommand acCmdFormView
Is there any way to hide the + sign indicating child records in the datasheet?
From: John W. Vinson on 3 Jul 2008 03:09
On Wed, 2 Jul 2008 22:38:00 -0700, NevilleT
<NevilleT(a)discussions.microsoft.com> wrote:

>I have a form and subform which I want to view as a datasheet for quick
>scanning purposes, Once I find the record I want, I double click a field
>which runs
> DoCmd.RunCommand acCmdFormView
>Is there any way to hide the + sign indicating child records in the datasheet?

Set the Query's Subdatasheet property to None (by default it's Auto).
--

John W. Vinson [MVP]
From: NevilleT on 3 Jul 2008 03:51
Hi John

Thanks for the advice but I am missing something. I can expand a
subdatasheet, and I see from help that I can remove it but how do I set it to
none? I want to do it in VBA rather than manually.

"John W. Vinson" wrote:

> On Wed, 2 Jul 2008 22:38:00 -0700, NevilleT
> <NevilleT(a)discussions.microsoft.com> wrote:
>
> >I have a form and subform which I want to view as a datasheet for quick
> >scanning purposes, Once I find the record I want, I double click a field
> >which runs
> > DoCmd.RunCommand acCmdFormView
> >Is there any way to hide the + sign indicating child records in the datasheet?
>
> Set the Query's Subdatasheet property to None (by default it's Auto).
> --
>
> John W. Vinson [MVP]
>
 | 
Pages: 1
Prev: API HELP
Next: access 2007 read-only