B3gbie
Thread Starter
- Joined
- Nov 30, 2001
- Messages
- 228
I'm trying to pass a value from a text box within one form to an SQL statement within another, upon clicking on cmdEdit the value is passed to a variable within a module (Which i think is now global) and the used within the second form.Private Sub
cmdEdit_Click()
AppointmentKey = txtAppKey.Text
frmEditApp.Show
End Sub
Dim sql As String
sql = "Select * From Appointments Where AppointmentKey = " & "'" & AppointmentKey & "'"
I cant get this to be accepted, any ideas why?
cmdEdit_Click()
AppointmentKey = txtAppKey.Text
frmEditApp.Show
End Sub
Dim sql As String
sql = "Select * From Appointments Where AppointmentKey = " & "'" & AppointmentKey & "'"
I cant get this to be accepted, any ideas why?