Closing a subform

rruston

unread,

Nov 10, 2009, 11:59:01 AM11/10/09

to

I am trying to make a subform close after one entry. The table behind the
subform has a one to one relationship with the table behind the main form.
I've tried everything I can think of, and can't find anything that works.
Help!

eda

unread,

Nov 10, 2009, 12:37:23 PM11/10/09

to

On Nov 10, 11:59 am, rruston <rrus...@discussions.microsoft.com>
wrote:

1) Right-click on the control and choose "properties"
2) Under the "Event" tab, for the "After Update" property, click the
"..." and choose "Code Builder"
3) Inside the Sub type:
DoCmd.Close

Ken Snell

unread,

Nov 10, 2009, 12:36:54 PM11/10/09

to

Make the subform control invisible.

--

Ken Snell
http://www.accessmvp.com/KDSnell/

"rruston" <rru...@discussions.microsoft.com> wrote in message
news:0803E17D-6ED1-4F31...@microsoft.com...

Beetle

unread,

Nov 10, 2009, 12:41:02 PM11/10/09

to

Set the Subform Controls Visible property to False;

Me![SubformControlName].Visible = False

You'll need to set it back to True again via some event;

Me![SubformControlname].Visible = True

Can't tell you which events to use since I don't know anything
about the circumstances.
--
_________

Sean Bailey

rruston

unread,

Nov 10, 2009, 10:24:49 PM11/10/09

to

OK. I can make a field disappear, but not the form. When I put the name of
the form in, it wants a field name. I know it's something I'm doing wrong....

Ken Snell

unread,

Nov 11, 2009, 12:22:43 AM11/11/09

to

The subform control is a control on the main form, and it's the control that
"houses" the subform itself. Open your main form in design view, click on
top edge of the control that is the subform, open the Properties window,
click on Other tab, and see the Name property. That is the name that you use
in the example "Visible = False" step.

--

Ken Snell
http://www.accessmvp.com/KDSnell/

"rruston" <rru...@discussions.microsoft.com> wrote in message

news:23CF9455-9D87-4DE3...@microsoft.com...

rruston

unread,

Nov 11, 2009, 10:55:02 AM11/11/09

to

I'm getting this error: Run-time error '424': Object required

With this code:

Private Sub List6_AfterUpdate ()
Invention.Forms![Invention Entry Form]![Open Lead Inventor Form].Visible =
False
End Sub

rruston

"Ken Snell" wrote:

> .
>

John W. Vinson

unread,

Nov 11, 2009, 11:58:15 AM11/11/09

to

On Wed, 11 Nov 2009 07:55:02 -0800, rruston
<rru...@discussions.microsoft.com> wrote:

>I'm getting this error: Run-time error '424': Object required
>
>With this code:
>
>Private Sub List6_AfterUpdate ()
>Invention.Forms![Invention Entry Form]![Open Lead Inventor Form].Visible =
>False
>End Sub
>

I think you need to remove the Invention. at the start of this string. What
does it refer to???

The syntax is

Forms![MainForm]![Subform].Visible = False

where MainForm is the name of the main form, and Subform is the name of the
*subform control* on the main form; this might be different from the name of
the form object within that subform control.
--

John W. Vinson [MVP]