print and use the fields of a temporary query in VBA

[aligoli]

hi !
I am a new programer by VBA and know I can't use the fields of a query . my codes are as below :

Dim mydb As Database
Dim str1 As String
Dim rsttemp As Recordset
Dim qdftemp As QueryDef
 
Private Sub Command1_Click()
 
            Set mydb = OpenDatabase("d:\pm_vb\main_db1.mdb")
 
                     str1 = "select * from users where per_code=" & Text1.Text
                      str1 = str1 + "and per_pass=" & Text2.Text
 
              Set qdftemp = mydb.CreateQueryDef("", str1)
                      If qdftemp.RecordCount <> 0 Then
 
           Text3.Text = qdftemp("per_code")
 
           Else
           Text4.Text = "NO"
            End If
 
End Sub

it would be appreciate if you could help me .

regards, Ali

[willakawill]

Hi. Is there any particular reason that causes you to use a querydef or is that just the way you think this process has to be done?

[aligoli]

Hi. Is there any particular reason that causes you to use a querydef or is that just the way you think this process has to be done?

Hi , by this way I'm going to control and access the components of a SQL statement . For example checking the user_ID and enterance password of my program and also set them in the forms, as the caption of a lable .
thank you

[willakawill]

I think it would be a good idea for you to work through some tutorials on vb and database projects. This would be a good place to start