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

[saji82]

Hi

Is it possible to see the datasheet view only when the search button is clicked and if there is result.

[gnawoncents]

saji,
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.

[NeoPa]

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.