Connect to SQL in ADP

[SQLScholar]

Hey all

I am trying to hide a text box - based on a query that runs on the database (its an ADP so database is SQL).

I have the below:

 Dim rs As DAO.Recordset
 Dim db As DAO.Database
 Dim strSQL As String

 Set db = CurrentDb()

 strSQL = "SELECT col1, col2, col3 FROM tablename WHERE fields = '" & database.form.txtbox & "'"

 Set rs = db.OpenRecordset(strSQL)

However I get an error on that last line saying "Object variable or With Block variable not set.

Any ideas? I am guessing it could be that i am not really connecting to access - but to SQL.

Dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[dhookom]

What is "database.form.txtbox"?

If you replace the expression with a constant value, does it work?

Do you actually have a field named "fields"?

Duane
Hook'D on Access
MS Access MVP

 

[SQLScholar]

No - it doesnt work with a constant. And it gets past that line. No i dont have those fieldnames - just removed to protect the innocent.

Thanks

dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[dhookom]

Have you ever used DAO with an ADP? I don't believe it will work.

Duane
Hook'D on Access
MS Access MVP

 

[SQLScholar]

Personally - i think that could also be the issue.

I have managed to find a way around it in a rather convoluted way but it works!

Thanks anyway.

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------