HI Mike,

>SELECT HINIT,HNAME FROM HWHOA WHERE (HINIT = @hinit)

From "Parameters in Data Adaptor Commands" in the doc, my understanding is that named parameters (@hinit) are only used with the sqldataadapter and that the placeholder (?) is only used with the oledbdataadapter. Im using the latter.

The querybuilder actually would not let me enter a named parameter. At any rate, I added "Hinit" to the parameter collection of my oledbdataadapter and it seemed accept the place holder.

No errors when I run the form but still not getting anything in the data set. Have to keep playing.

Thanks for your help!

Todd