I have a form with a subform in datasheet view. When I open the form, it 
opens fine, but it opens the table that is related to the subform. When I 
close the form using my close button, it closes the forms, but the table is 
still open. I have many forms/subforms in my database, but this is the only 
one that I'm having trouble with. Can someone please help me? Thanks!!!

When you say "opens the table", what do you mean?  If Access is actually 
opening the table object, and not the subform, or a query, then I'm guessing 
there's code that's telling Access to open that table.  Does your main form 
(or subform) have any code behind it/them?

As it's design and normally operates, Access doesn't open tables unless told 
to...

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

-- 
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"tsquared1518" <tsquared1518@discussions.microsoft.com> wrote in message 
news:D6C942B1-D17D-4848-9F98-41EA25DEA02A@microsoft.com...
>I have a form with a subform in datasheet view. When I open the form, it
> opens fine, but it opens the table that is related to the subform. When I
> close the form using my close button, it closes the forms, but the table 
> is
> still open. I have many forms/subforms in my database, but this is the 
> only
> one that I'm having trouble with. Can someone please help me? Thanks!!! 

Basically, what happens is when I open the form from the switchboard, it 
opens up fine. When I enter data and go to close it, the main form closes 
fine, but the subform (in datasheet view) is still open, and I have to close 
it by clicking the "X" in the top right corner.

"Jeff Boyce" wrote:

> When you say "opens the table", what do you mean?  If Access is actually 
> opening the table object, and not the subform, or a query, then I'm guessing 
> there's code that's telling Access to open that table.  Does your main form 
> (or subform) have any code behind it/them?
> 
> As it's design and normally operates, Access doesn't open tables unless told 
> to...
> 
> More info, please...
> 
> Regards
> 
> Jeff Boyce
> Microsoft Access MVP
> 
> -- 
> Disclaimer: This author may have received products and services mentioned
> in this post. Mention and/or description of a product or service herein
> does not constitute endorsement thereof.
> 
> Any code or pseudocode included in this post is offered "as is", with no
> guarantee as to suitability.
> 
> You can thank the FTC of the USA for making this disclaimer
> possible/necessary.
> 
> "tsquared1518" <tsquared1518@discussions.microsoft.com> wrote in message 
> news:D6C942B1-D17D-4848-9F98-41EA25DEA02A@microsoft.com...
> >I have a form with a subform in datasheet view. When I open the form, it
> > opens fine, but it opens the table that is related to the subform. When I
> > close the form using my close button, it closes the forms, but the table 
> > is
> > still open. I have many forms/subforms in my database, but this is the 
> > only
> > one that I'm having trouble with. Can someone please help me? Thanks!!! 
> 
> 
> .
> 

Also, when I switch from design view to form view, the subform opens up, and 
I have to close it to see the main form with the subform. 

"tsquared1518" wrote:

> Basically, what happens is when I open the form from the switchboard, it 
> opens up fine. When I enter data and go to close it, the main form closes 
> fine, but the subform (in datasheet view) is still open, and I have to close 
> it by clicking the "X" in the top right corner.
> 
> "Jeff Boyce" wrote:
> 
> > When you say "opens the table", what do you mean?  If Access is actually 
> > opening the table object, and not the subform, or a query, then I'm guessing 
> > there's code that's telling Access to open that table.  Does your main form 
> > (or subform) have any code behind it/them?
> > 
> > As it's design and normally operates, Access doesn't open tables unless told 
> > to...
> > 
> > More info, please...
> > 
> > Regards
> > 
> > Jeff Boyce
> > Microsoft Access MVP
> > 
> > -- 
> > Disclaimer: This author may have received products and services mentioned
> > in this post. Mention and/or description of a product or service herein
> > does not constitute endorsement thereof.
> > 
> > Any code or pseudocode included in this post is offered "as is", with no
> > guarantee as to suitability.
> > 
> > You can thank the FTC of the USA for making this disclaimer
> > possible/necessary.
> > 
> > "tsquared1518" <tsquared1518@discussions.microsoft.com> wrote in message 
> > news:D6C942B1-D17D-4848-9F98-41EA25DEA02A@microsoft.com...
> > >I have a form with a subform in datasheet view. When I open the form, it
> > > opens fine, but it opens the table that is related to the subform. When I
> > > close the form using my close button, it closes the forms, but the table 
> > > is
> > > still open. I have many forms/subforms in my database, but this is the 
> > > only
> > > one that I'm having trouble with. Can someone please help me? Thanks!!! 
> > 
> > 
> > .
> > 

I figured it out, thanks for your help!!

"tsquared1518" wrote:

> Also, when I switch from design view to form view, the subform opens up, and 
> I have to close it to see the main form with the subform. 
> 
> "tsquared1518" wrote:
> 
> > Basically, what happens is when I open the form from the switchboard, it 
> > opens up fine. When I enter data and go to close it, the main form closes 
> > fine, but the subform (in datasheet view) is still open, and I have to close 
> > it by clicking the "X" in the top right corner.
> > 
> > "Jeff Boyce" wrote:
> > 
> > > When you say "opens the table", what do you mean?  If Access is actually 
> > > opening the table object, and not the subform, or a query, then I'm guessing 
> > > there's code that's telling Access to open that table.  Does your main form 
> > > (or subform) have any code behind it/them?
> > > 
> > > As it's design and normally operates, Access doesn't open tables unless told 
> > > to...
> > > 
> > > More info, please...
> > > 
> > > Regards
> > > 
> > > Jeff Boyce
> > > Microsoft Access MVP
> > > 
> > > -- 
> > > Disclaimer: This author may have received products and services mentioned
> > > in this post. Mention and/or description of a product or service herein
> > > does not constitute endorsement thereof.
> > > 
> > > Any code or pseudocode included in this post is offered "as is", with no
> > > guarantee as to suitability.
> > > 
> > > You can thank the FTC of the USA for making this disclaimer
> > > possible/necessary.
> > > 
> > > "tsquared1518" <tsquared1518@discussions.microsoft.com> wrote in message 
> > > news:D6C942B1-D17D-4848-9F98-41EA25DEA02A@microsoft.com...
> > > >I have a form with a subform in datasheet view. When I open the form, it
> > > > opens fine, but it opens the table that is related to the subform. When I
> > > > close the form using my close button, it closes the forms, but the table 
> > > > is
> > > > still open. I have many forms/subforms in my database, but this is the 
> > > > only
> > > > one that I'm having trouble with. Can someone please help me? Thanks!!! 
> > > 
> > > 
> > > .
> > > 

Someone else in the future may be faced with the same issue ... consider 
posting your solution.

Regards

Jeff Boyce
Microsoft Access MVP

-- 
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"tsquared1518" <tsquared1518@discussions.microsoft.com> wrote in message 
news:D51F17E7-EE66-46AA-8423-10A7DDECA539@microsoft.com...
>I figured it out, thanks for your help!!
>
> "tsquared1518" wrote:
>
>> Also, when I switch from design view to form view, the subform opens up, 
>> and
>> I have to close it to see the main form with the subform.
>>
>> "tsquared1518" wrote:
>>
>> > Basically, what happens is when I open the form from the switchboard, 
>> > it
>> > opens up fine. When I enter data and go to close it, the main form 
>> > closes
>> > fine, but the subform (in datasheet view) is still open, and I have to 
>> > close
>> > it by clicking the "X" in the top right corner.
>> >
>> > "Jeff Boyce" wrote:
>> >
>> > > When you say "opens the table", what do you mean?  If Access is 
>> > > actually
>> > > opening the table object, and not the subform, or a query, then I'm 
>> > > guessing
>> > > there's code that's telling Access to open that table.  Does your 
>> > > main form
>> > > (or subform) have any code behind it/them?
>> > >
>> > > As it's design and normally operates, Access doesn't open tables 
>> > > unless told
>> > > to...
>> > >
>> > > More info, please...
>> > >
>> > > Regards
>> > >
>> > > Jeff Boyce
>> > > Microsoft Access MVP
>> > >
>> > > -- 
>> > > Disclaimer: This author may have received products and services 
>> > > mentioned
>> > > in this post. Mention and/or description of a product or service 
>> > > herein
>> > > does not constitute endorsement thereof.
>> > >
>> > > Any code or pseudocode included in this post is offered "as is", with 
>> > > no
>> > > guarantee as to suitability.
>> > >
>> > > You can thank the FTC of the USA for making this disclaimer
>> > > possible/necessary.
>> > >
>> > > "tsquared1518" <tsquared1518@discussions.microsoft.com> wrote in 
>> > > message
>> > > news:D6C942B1-D17D-4848-9F98-41EA25DEA02A@microsoft.com...
>> > > >I have a form with a subform in datasheet view. When I open the 
>> > > >form, it
>> > > > opens fine, but it opens the table that is related to the subform. 
>> > > > When I
>> > > > close the form using my close button, it closes the forms, but the 
>> > > > table
>> > > > is
>> > > > still open. I have many forms/subforms in my database, but this is 
>> > > > the
>> > > > only
>> > > > one that I'm having trouble with. Can someone please help me? 
>> > > > Thanks!!!
>> > >
>> > >
>> > > .
>> > >