Display parameter box from form

[WalfdPD]

I am new to VB.net having used access 2000 to write most of my applications.

I have a simple query written with the Data Adapter Configuration Wizard. It has two parameters and works fine when it is run in the query builder view.
I want to run the query from a form and it runs fine without the parameters. However I want the parameter box to display so the user can enter his/her parameters and get the results he/she is looking for.

I presently have the following code attached to a button.
OleDbDataAdapter1.Fill(DataSet11)

Without the parameters it works fine returning all the records in the table. However with the parameters I get
this message;
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll QueryTest\Form1.vb:line 1The program '[924] QueryTest.exe' has exited with code 0 (0x0).

What am I missing?

Can't seem to find the answer in MS help.

tks LTWHB

 

[SBendBuckeye]

Are you creating parameter objects and adding them to the command object anywhere? Good Luck!

Dim parm As New OledbParameter("ParmName", ParmValue)
OledbDataAdapter.SelectCommand.Parameters.Add parm

Have a great day!

j2consulting@yahoo.com