Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form, Requery the query behind the form 1

Status
Not open for further replies.

blackte

Programmer
Jul 24, 2001
80
US
Maybe I'm asking about the wrong command, but I have a form that instead of using a find button to locate records, I would like to re-run the query behind the form. I have an event with the following command, but when the button is pressed it asks for each input criteria for the sql twice. Have I got the statement coded correctly or should I be using some other command. Thanks in advance for any help.


Me.Requery
Forms("project_timeline_form").Requery

Thanks again, Travis
 
If both statements refer t the same form then get rid of the second one. If they are the same frm the reason your getting two prompts is because your requirying it twice. Just use Me.Requery
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top