Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

MS Access 2000 - Changing Subforms within a form

MS Access 2000 - Changing Subforms within a form

MS Access 2000 - Changing Subforms within a form

Heeellllppppp. I've got to a sticking point and the books and Help function don't seem to get me any further.

I have a number of tables and I would like to display the information in one form. I don not wish to display all of the tables at once, only one at a time.

I thought of doing this by having a main form with buttons on and then having subforms that would change when the various buttons are pressed.

I understand that the code:

stDocName = "DaltonTest"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

will open a new Window with the form in but this ain't what I want. Does anybody know of a way of opening a form in the way I want, or am I totally going around it in the wrong way?

Any help would be much appreciated.

RE: MS Access 2000 - Changing Subforms within a form

One thing I've learned over the years is that if you fight with Access over user interface issues, Access will win. You can't fight City Hall.

However, if you really, really want to house six tables in one form without joining them, I think your subform idea will work as well as anything can. Just use your selection buttons to hide all the subform controls except the one corresponding to the button, which you unhide. I can't guarantee the performance will impress anybody when you open the main form, though--Access will have to run the queries under all the subforms before it displays anything.

There is another possibility in the special case that the fields you want to display are all the same regardless of which table they're in. In this case, you could use just one form and change its Record Source to the appropriate table. Refresh the form and you're done.

Rick Sprague

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close