Updating tables when you input new data

Apr 30, 2015
Reaction score
I am new to Access and I am using Access 2013.

I want to get the associated tables that are associated with a subform/table to update automatically with new data when it is inputted into the relevant field in the subform/table.

What I mean is, the relevant tables are called Production Companies, Casting Directors, Directors and the main table Submitted (which is the subform/table). The Submitted Table has the following fields Month/Yr Submitted, Role, Production, Pay, Production Company, Casting Director, Director, Notes, Production Date, Shoot Date and Location and I want to be able to input new production companies, Casting Directors and Directors using the subform/table so that they will update the separate tables each time there is a new entry is done (the fields are set to no duplicates) and they are combi boxes.

Any help will be appreciated.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question