really stupid question

[jasn_78]

hey guys sorry to ask this as i know its probably really easy but being a newbie jut having trouble figuring it out in the below code i need to put the value of the txtPATH text box into the connection string and i cant seem to every code i try is just return the actual text of the code

any help would be great


Private Sub cmdQRYREFRESH_Click()


Dim db As Dao.Database
Dim qdf As Dao.QueryDef


Set db = CurrentDb
Set qdf = db.QueryDefs("QRYLUCA")

qdf.Connect = "ODBC; SERVER= & txtPath.Value ; DSN=FUTUREIB; " & _
"UserID=SYSDBA; PW=masterkey;"

End Sub

 

[jasn_78]

as per usual once i post on here the answer comes to me sorry bout that guys.

 

[ajetrumpet]

there is no such thing as a stupid question.

The only stupid thing to do is not wanting to fight for the answers.