How do I get multiple checkboxes to write to one field?
In other words, how do I get Checkbox1 with value X, Checkbox2 with value Y, and Checkbox3 with value Z all to write to one field in my table. The table field would therefore read (X Y Z).
Thanks.

You could do that using code, but why would you want to? Store the information in three separate fields and concatenate them in the form or report control when you output the information.

I know how to store in 3 different fields, but i need to know how to do it in one due to integration/automation issues between couple of different databases.

Could you please provide me with an example of what/how the code would be?

Check out this link. It talked about the same thing.
http://www.access-programmers.co.uk/ubb/Forum7/HTML/001829.html