Checkboxes in a form, how to save the data

[alex423]

I'm kind of new using access 2010, I'm creating a DB to store the information about computers (Assets) for a company, to try to make my life a little easier I'm using one of the templates from Microsoft Office and I'm doing some modifications to it.



I have a form named Assets Details, where I enter the details for each computer (i.e: Type of computer, Manufacturer, Model, etc) the last Tab in that form is the Software installed on each machine. In this example I added 3 Checkmarks just for purpose of testing (Antivirus, Windows Updates, Microsoft Office) but actually it will be more than 20 different software that can be installed in one machine.

I'm using the checkboxes just to have an easy interface for the customer, so if the customer installed the antivirus he just need to click the check mark and that's it. I'm trying to follow this explanation on this website http://allenbrowne.com/casu-23.html but instead of having a subform with a combo I would like to have the check boxes.

I have 3 tables Assets (Where I save the details for each computer), table Software (where I store the list of software, i.e. 1 Antivirus, 2 Windows Updates, 3 Microsoft Office, etc) and my 3rd table is Software Installed where I store what software is installed to each computer.

My question is how can I save the data in my 3rd table (Software Installed) using the Checkmarks, since a checkmark is a yes/no control. Any help with this is really appreciated, I've trying to figure it out how to work with a checkmark but I'm giving up

I'm attaching the database so any of you can look at my form "Asset Details" and my relationships.

[June7]

Use code to write records to Software Installed table for each checkbox selected. Something like:

If Me.Chkbox1 Then CurrentDb.Execute "INSERT INTO [Software Installed](AssetID, SoftwareID) VALUES(" & Me.ID & ", 1)"

The real trick is figuring out what event to put code in - maybe the form AfterUpdate event. Also, there is the issue of preventing duplicate entries. One way is to set ID (rename to AssetID) and SoftwareID in Software Installed as a compound primary key.


BTW, advise no spaces or special characters/punctuation (underscore is exception) in names

[alex423]

Thank you