Hi,
How do I update a table with values on the form.I can do this if the form has only text boxes with the statement
sSQL= " UPDATE Tabename SET columnname = " & Me.Formfieldname & "
DoCmd.RunSQL(sSQL)
But what if the form has combo boxes and option buttons and I want to update the tabel with the values selected.
I am using Access2000,appreciate any help,
Thanks,
C
How do I update a table with values on the form.I can do this if the form has only text boxes with the statement
sSQL= " UPDATE Tabename SET columnname = " & Me.Formfieldname & "
DoCmd.RunSQL(sSQL)
But what if the form has combo boxes and option buttons and I want to update the tabel with the values selected.
I am using Access2000,appreciate any help,
Thanks,
C