Noob Question macro to check checkbox

[bradmitchell]

Hi Guys I have no training in aand no idea how to use VBA..... I have set up a simple database to enter data into then upload to a client web portal.

I have a form to enter the data and the table this data goes into has a check box at the end which I want to have ticked/checked/True after I have exported.

I have created a query that showes me all data that is un checked (not yet exported to an xls)

I have created a simple export macro that sends the query result to an .xls

I want the macro to finish by checking the "export" checkbox once I have done this....

I am using Access 2010 attached is a screen dump of what I have so far



any assistance with a simple solution for a noob would be appreciated

[bradmitchell]

K so I did an append then created a button to mark them as true its not a one click solution but its the best I can do as a beginner, would still appreciate help if you guys have anything to add