<div>
?? do you mean looping through the checkboxes??<br />
<br />
private sub someButon_click()<br />
<br />
If me.chkFile1.value = -1 then<br />
&nbsp; &nbsp;'do some thing with file 1<br />
end if<br />
<br />
If me.chkFile2.value = -1 then<br />
&nbsp; &nbsp;'do some thing with file 2<br />
end if<br />
<br />
If me.chkFile3.value = -1 then<br />
&nbsp; &nbsp;'do some thing file 3<br />
end if<br />
<br />
If me.chkFile4.value = -1 then<br />
&nbsp; &nbsp;'do some thing with file 4<br />
end if<br />
<br />
<br />
Not sure what you area asking mate<br />
<br />
Dave
</div>


?? do you mean looping through the checkboxes??

private sub someButon_click()

If me.chkFile1.value = -1 then
   'do some thing with file 1
end if

If me.chkFile2.value = -1 then
   'do some thing with file 2
end if

If me.chkFile3.value = -1 then
   'do some thing file 3
end if

If me.chkFile4.value = -1 then
   'do some thing with file 4
end if


Not sure what you area asking mate

Dave

<div>
Thank you very much mate !! You've asked my question within your answer !<br />
<br />
Cheers ..<br />
P.S. I am new to this site. Do I have to do something to give you your points or do you automatically recieve them... <br />
<br />
Thanks again .<br />

</div>


Thank you very much mate !! You've asked my question within your answer !

Cheers ..
P.S. I am new to this site. Do I have to do something to give you your points or do you automatically recieve them...

Thanks again .


<div>
... I mean you've answered my question within your answer ........loooooooooooong day .huh
</div>


... I mean you've answered my question within your answer ........loooooooooooong day .huh

<div>
<div class="content wysiwyg-content">
I have 4 check boxes in a form representing files, so that when chosen by a user and clicking a command button, an import operation of every chosen file would take place.<br />
<br />
Question: Can a check box be used &nbsp;in this case (ie multiple selection)?<br />
<br />
My real trouble is &quot;how do I code these check boxes&quot; on my command button. <br />
Please help ! Thanks a milliom ........<br />
&nbsp; &nbsp;
</div>
</div>


I have 4 check boxes in a form representing files, so that when chosen by a user and clicking a command button, an import operation of every chosen file would take place.

Question: Can a check box be used  in this case (ie multiple selection)?

My real trouble is "how do I code these check boxes" on my command button. 
Please help ! Thanks a milliom ........
   

Coding simple check boxes.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.