Advertisement
Guest User

Untitled

a guest
Apr 24th, 2014
36
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. Private Sub Command106_Click()
  2. Dim qry_rs As DAO.Recordset
  3. Dim qry_db As Database
  4. Set qry_db = CurrentDb
  5. SQLString = "SELECT [Clients Info].* FROM [Clients Info] WHERE ((([Clients Info].Info_Client)='" & [Forms]![Form-1]![Combo13_PageOne_Name] & "'));"
  6. Set qry_rs = qry_db.OpenRecordset(SQLString)
  7. Forms![Form-1].[Info_Member].Value = qry_rs![Info_Member]
  8. Forms![Form-1].[Info_Tower].Value = qry_rs![Info_ID]
  9. End Sub
  10.  
  11. Forms![Form-1].[Info_Picture].Value = qry_rs![Info_UserIDPhoto]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement