Parameter pop up when form opens

[JPinter]

Hello,

I have a form that has a list box box on it. It is hook to a parameter query, so when I click a buttom i type something in and it comes up in the list box. The problem is when open the form the parameter box comes up and I dont want it to. I only want it to come up when I click the Button on the form.

 

[SBendBuckeye]

Is the parameter query the data source for your form? If so, just clear the data source and run it from a button on the form as you stated.

Good Luck! Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!

 

[JPinter]

No, it is not a part of the control source of the form. The parameter is a part of the row source for a list box. When I open the form before the form will open, it ask for a parameter which I do not want it to. I Only want it to ask for a parameter when I click the command button I Have set to requery on click.

 

[SBendBuckeye]

Try clearing the row source for your list box and then setting it again from the command button click event. I haven't tried this, just thinking out load trying to help.

Good Luck! Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!