Create a Form to Update a Table . . .

Howdy All! New to the forum and pretty new to Access (I'm better with Excel).

New job uses a lot of Access - I need help desperately :banghead:

I've got two tables - one that works like a cypher and one with all my records.

I have 2 queries. One that is a simple query that extracts data that is not so user-friendly and puts it into a user-friendly format. The Other query is for any records that the first query excludes because the new combination of data (lets just call it a code) is not in the cypher table, but needs to be added.

How do a create a form that will show the records in the 'excluded records' query and allow me to select from a drop-down list a specific set of categories to update the cypher table ?

Example :

Record Table: Cypher Table:

Ford Focus = Sedan
Ford F-150 = Truck
Ford Freestyle = Wagon
Ford Escape = SUV

Now a new model comes in, a Ford Edge which is an SUV but is not in my cypher table.

I have the query to pull in the excluded Ford Edge, but I want a form to show "Ford Edge" in the first column and be able to select from a drop-down list "SUV", and either automatically update my cypher table or require me to press a button to update the table (whichever is easier).

I don't know VBA or any programming languages :confused: (I need to learn, I know)

But I know this shouldn't be difficult to achieve.

CAN ANYONE HELP PLEASE!?!?!?!?! :D

Create a Form to Update a Table . . .