Loading drop down lists

[Joe]

I have created a reporting system using an ADP linking to
my SQL 2000 server. My Stored Procedures require
parameters. I created a button in the ADP to run the SP.
when I click on the button it opens a parameter MSG box, I
enter the parameter and all is well.

Is there a way for me to populate the drop down in the
parameter box? there is a drop down that has 2 choices,
<DEFAULT> and <NULL>.

can I load this from a table, or even just save the few
values I need?

Thanks,
Joe

 

[Peter Kaufman]

Joe, I' ve never done it that way so I can't say for sure, but why
don't you just create an modal input form instead of the message box?.

Hide the original form when it opens then make it visible again when
the other one closes. Run the SP from the input form. It's much more
flexible than a message box, and you may find you can use it in
multiple locations. You can easily populate the criteria boxes from
lookup tables.

Peter