Parameter query from a vb.net form to an mdb database

[rambleon]

I need to construct a Select statment to query an mdb database from a vb.net windows form.
The Select statement is:
SELECT * from EmployeeTable Where EmployeeNumber = Me.EmployeeNumberTxt

Me.EmployeeNumberTxt is input from a TextBox on the form before executing the query.
Can someone please tell me what the format of this parameter query should be.

Thanks

Rambleon

 

[earthandfire]

You could try:

"SELECT * FROM EmployeeTable WHERE EmployeeNumber = " + Me.EmployeeNumberTxt.Text


Hope this helps.

 

[rambleon]

Thanks for your reply, I haven't tried it yet. I also discovered the following format (which I haven't tried either):

SELECT * FROM EmployeeTable WHERE (EmployeeNumber = ?)

Is this type of parameter query OK with mdb (Access 2000) databases