Check Boxes- how do I get them to Report a Text Value

[murphysdad]

I am using Access 97 and am having a problem having the check boxes return a text value to my table. the users should be able to choose one or many different boxes and I want the checked ones to report text to one field(have that one feild accept one or many peices of text(?)).

Also,
After they hit the submit button, how do I get these check boxes to clear?

JJ

"Smile and the world smiles with you, sneeze and it's good- bye Chicago" - Steve Martin, Roxanne.

 

[Orion45]

How about something like this...

If chk1 = 1 Then
docmd.setwarnings false  'stops the annoying update warning
docmd.runsql "UPDATE TableName Set Field = "text"  WHERE Field2 = criteria;"
docmd.setwarnings true
chk1 = 0
End If

hope this helps

 

[murphysdad]

For the SQL statement should there be a comma after "update tablename"? Also, what is "field2" refering to?