Add New Record to Different Table Then Form

[Jace Campbell]

I have a form where I create menu items from a subform of ingredients. I
would like to make a checkbox or command button that when clicked, will add
the menu item as a new record in the ingredients table and make the
ingredient cost in the ingredient table the same as the calculated cost of
the menu item. I'm not sure how I can make this work even though I think it
has something to do with using VBA and an append query.

Thanks for the help.