I have a form that has two buttons

[atadbitslow]

I have a form that has two buttons for the user to choose how to sort the form. Behind the buttons are two different macros--they use the setvalue action to set the recordsource of the form to two different queries depending on the sort choice. The queries ask the user to enter a starting date to sort from......my problem is that the box that pops up for the user to enter the start date, pops up twice! I have the same form and queries in A97 and it works fine, but seems like something in A00 is causing it to happen.....

Any ideas??

Thanks! Excuse my confusion....it's only temporary......

 

[IcesMaster]

You migh be using parameter query that asking the parameter.

You better set the parameter in the form and asked the form to requery.
Sory I do not so clear about your problem.

 

[SVO4Turbo]

I've had this happen to me before as well. I placed the input for the sort date (in your case) on the form itself. Then, in the query, I reference the input box on the form. In the criteria field for the date, for example, [Forms]![frm_FormName]![FormFieldName]. I don't know why, but this worked for me.