Can you use a macro to create a record? If so, how? I assume you could just write VB code to do it, but I don't know VB, so I was gonna try to get a macro to do it for me. Thanks

I think you are confusing macros in access with macros in other products.

I would suggest you look at doing it with VBA, I do not know if it is possible with macros or not, I have never use them! I don't think it is possible though that is my gut feeling.

Ok. I have a two tables and a junction table. The two tables each only have two fields: a key field and a data field. One for states, one for issues. The junction table is for their relationship, since one issue can apply to many states, and one state can have many issues. Here is what I want to do:

I want a form where the user inserts an issue, and then checks (or leaves uncheked) a checkbox to indicate whether or not the issue affects a certain state. So, there are 50 checkboxes. Then the user will hit a button.

When the button is pressed, I need to create a record in the junction table for each checked state. Make sense? How would I do that?