Macro to append data

[schmidt1962]

I am a newbie at access programming. I have a form that uses a subform to display data from 4 linked tables. One table (let's call it site) is linked to a media/chemicals table in a one site to many media/chemicals. The media chemicals table is then linked via a many to one to two separate tables,1) description, and 2) chemical name.

what I would like in the form is for users to have the ability to add new records, doing so via drop down boxes. If they want to add new media/chemicals associated with a particular site, they can do so via a form. Is this possible, or does it need to be done using a userform and macro? Thank you!

[June7]

That's what forms are for - as a user interface for data entry/edit.

Usually, a form can do data entry/edit for only 1 table.

Options:

1. single form bound to the table that has records that associate site with chemicals (this is a 'junction' table) - select site and chemical from comboboxes to create a single record

2. form/subform - main form bound to site table, subform bound to the junction table, combobox to select chemical

3. form/subform - main form bound to chemical table, subform bound to the junction table, combobox to select site