Check Boxes linked to table?

[natonstan]

I basically have a form with a list of check boxes, I then have a seperate table for each check box. Basically what I am trying to do is have an Export button at the bottom of the form, so that depending on which check boxes are checked, it will export the data in the linked table.

Can anyone give me any advice on how to do this? I've never really worked with check boxes before so this is all alien to me.

[June7]

So you need If Then structures:

If Me.checkbox1 Then
'code to export table1
End If

If Me.checkbox2 Then
'code to export table2
End If

etc.

[natonstan]

Here's the code I ended up going with:

If Me.Check439 Then
outputFileName = CurrentProject.Path & "\Export_" & Format(Date, "yyyyMMdd") & ".xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblEastSoutheastAsia", outputFileName, True
End If

[June7]

It works? Issue solved?

[natonstan]

Issue is solved, just trying to get the file location to save to users Desktops now, but you can mark this one solved as the original issue is fixed, thanks for the help!

[June7]

Review http://stackoverflow.com/questions/1...rdless-of-user