Hi Mike,

>SELECT HINIT,HNAME FROM HWHOA WHERE (HINIT = ?)

>You should still get the parameter(s) generated by the wizard. To check go
>to oledbdataadapter properties, selectcommand, parameters collection. You
>should see the created parameter list. To test go to oledbdataadapter
>properties and select preview data. Add in the desired parameter values
>and hit Fill Dataset. You should get the data returned (At least it works >for me).

THAT WORKS! I do get an error when using the oledbdataadaptor creation wizard that a "parameter is missing" but it does create the paramater list but it does fill the dataset based on my parameter value.

Sorry for the slow response to your message, havent been on the UT for a while due to daily distractions.

Thanks again for your help.

Todd