[RESOLVED]retrieving data from the database using SQL query

[pame1a]

I have a form that retrieves data from the database and shows the record fields in text boxes...

I have retrieved data using the properties window.... I called the datasource the reuiqred database and have assiged a datafield...this works expect it returns the first record in the table...I want it to return the data for a certain ID no (which is in textbox 'IDtxt' on the form)

So I created the following query with in the command:

SELECT * FROM customer WHERE (customerID = 'frmUpdate.IDtxt.Text')

this does not work however if I change 'frmUpdate.IDtxt.Text ' to 2 it does work and returns the 2 record in the table...


what am I doing wrong in the above query?????