By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,251 Members | 2,764 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,251 IT Pros & Developers. It's quick & easy.

Open subform via command button

P: 16
I was wondering if it is possible to open a subform via clicking a command button on the main form? Just looking for a yes or no here so that I have a better idea of what possibility to pursue. Thanks!
1 Week Ago #1

✓ answered by twinnyfo

Kledki,

This is not a yes or no answer, because it is a faulty question. Typically, you don’t “open” a Sub-Form, because if it is a sub-form, it is opened when you open the parent form. However, you could make it visible or not based upon the usage of a command button.

Share this Question
Share on Google+
3 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,257
Kledki,

This is not a yes or no answer, because it is a faulty question. Typically, you don’t “open” a Sub-Form, because if it is a sub-form, it is opened when you open the parent form. However, you could make it visible or not based upon the usage of a command button.
1 Week Ago #2

NeoPa
Expert Mod 15k+
P: 31,433
That's the perfect answer for that question. We'll happily expand on that for you if you require but I guess, from your question, you're probably not looking for more there.

For now you at least know what is and isn't possible, and what makes sense.
4 Days Ago #3

twinnyfo
Expert Mod 2.5K+
P: 3,257
Expand|Select|Wrap|Line Numbers
  1. Me.SubformName.Visible = True/False
Use that in the OnClick Event of the Command button.
8 Hours Ago #4

Post your reply

Sign in to post your reply or Sign up for a free account.