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

Set Datasheet to Visible if I Search for Something in MS Access Form

P: 1

Is it possible to see the datasheet view only when the search button is clicked and if there is result.
Dec 22 '17 #1
Share this Question
Share on Google+
2 Replies

P: 213
The answer is probably "yes," but we need a little more information to go on here. Are you trying to press the button and have the datasheet view of a form appear only if the form exists or based on some user inputted data? Please explain the question in more detail and we can guide you toward a solution.
Dec 29 '17 #2

Expert Mod 15k+
P: 31,411
Please try to ask your question fully and properly. It doesn't help when members post questions without any details and forgetting to include important parts of the question. If you'd like experts to spend time and effort on your question it's only fair that you can be bothered to spend a small amount of effort writing out your question fully after first considering what it is you need to say.

Are you asking about setting the .Visibility property when the search is found to be successful? Or are you asking about setting the View mode? Or maybe both? What exactly is it that you envisage happening with your form? Is the object you're talking about the same form as that where the search is initiated? Is it a Sub-Form? Is it a separate form that's already open? Or maybe one that needs to be opened if, and only if, the search succeeds?

When we know what you are actually asking for then we will be in a far better position to offer you help. Your responsibility is to ask a question that makes sense up front.
Dec 29 '17 #3

Post your reply

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