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

Displaying query results in a form based on selected criteria

P: n/a
Hi
I have created a form which is derived form a query the query has a
prompt box which prompts the user to input the criteria they wish to
see.
I have worked out how to put a command button into the form and when
they click this button the prompt box appears. but the format changes
completely in that it returns it in a simple query format and not in
the form format that I wish to see it in.
HOw do I get access to run or even open the form again to give the
prompt box without having to close and open the form each time, and to
provide it in the format required...
does this make sense..

any help would be much appreciated...

Jul 25 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Wed, 25 Jul 2007 04:41:32 -0700, dy****@crosslandtankers.com wrote:

I think it's a one-liner in the Click event of your button:
Me.Requery

-Tom.

>Hi
I have created a form which is derived form a query the query has a
prompt box which prompts the user to input the criteria they wish to
see.
I have worked out how to put a command button into the form and when
they click this button the prompt box appears. but the format changes
completely in that it returns it in a simple query format and not in
the form format that I wish to see it in.
HOw do I get access to run or even open the form again to give the
prompt box without having to close and open the form each time, and to
provide it in the format required...
does this make sense..

any help would be much appreciated...
Jul 25 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.