Using Insert query in Module

[saleem]

I m trying to insert record in table via following code on click event

Private Sub Command8_Click()
Dim conn As ADODB.Connection


Set conn = CurrentProject.Connection

conn.Execute "INSERT INTO master VALUES ( & forms!m!Text2& ", " & forms!m!text2& );"

when i give values here directly the code works...but when i want it to pick values from form..it doesnt..any idea..where i m wrong...

saleem

 

[Jack Cowley]

conn.Execute "INSERT INTO master (Field1, Field2) VALUES ('" & Me![Text1] & "', '" & Me![Text3] & "' );"

Replace the field names with the ones in your table and on your form.

 

[saleem]

got it....thanks