input parameters

[greentree20042001]

I have made research but I haven't gotten the answer for my question. I have the record source is a stored procedure call and the input parameter is a value selected from the combo box from the main form. The stored procedure will return all records that are matched with the value passed from the main form. Everything works fine except the dialog box keeps poping up prompts for the input value from the user

I don't want this dialog box poping up. How can I do it

Thanks
Gree

 

[Eric Cardenas]

I have made research but I haven't gotten the answer for my
question. I have the record source is a stored procedure call
and the input parameter is a value selected from the combo
box from the main form. The stored procedure will return
all records that are matched with the value passed from
the main form. Everything works fine except the dialog box
keeps poping up prompts for the input value from the user.

I don't want this dialog box poping up. How can I do it?

--------------
It will be more involved than you expect. Because you are using a pass
through query, you can't pass variable parameters. To accomplish this you
need to change the record source on the fly with the correct parameters
accordingly.

Hope this helps,