Problem With Form

[tsquared1518]

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!!!

 

[Jeff Boyce]

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]

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.

 

[tsquared1518]

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]

I figured it out, thanks for your help!!

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.

 

[Jeff Boyce]

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.