Multi Update By Checkbox

[Nsquared]

Can anyone help me, I am new to creating forms and there functions, what I want to achive is for the information form the textboxs CampDetails, CampDate and NoNights to be put into the into table tbl_Camps for each of the members selected by the checkbox called itemcheck when I click on the Update Records Button.

I have attached a picture of the form below (CampUpdate.JPG)

The code I have created so far is

Private Sub UpdateRecords_Click()



DoCmd.RunSQL "INSERT INTO tbl_Camps (Camp, DateOfCamp, noofnights) VALUES (CampDetails, CampDate, NoNights)"

End Sub

Any help is greatly appreciated

[pbaldy]

Personally I would use a multiselect listbox:

http://www.baldyweb.com/MultiselectAppend.htm

Though the technique could be modified to step through what I assume is a subform listing people at the top of your form.

[Nsquared]

Thanks PBaldy

Your Program was just what I was looking for.

Question, can your program be modified use the results from a combobox instead of a txtbox

[pbaldy]

Absolutely; you could point to any control that has a value you want to use, and you can have more than one.