Trouble with command button and run query

[CG23]

I'm a newbie to Access and I'm wondering if anyone can help me figure this out:



I have one large table (MainTable) with all my variables and 6 data entry forms. Each form is bound to its own separate table created from MainTable. I've created a command button at the end of the forms that saves the record and loads a clean form, but I would also like it to run one of 2 queries: If ID on the form is already a record on MainTable, run UpdateQuery, but if the ID is not a record on MainTable, run AppendQuery and add only the newly added record (queries have already been created and ID is the primary key on all tables).

Anyone have any ideas on how I can do this???

[orange]

The important thing at the beginning is to get your tables designed/structured properly. This will require Normalization. I'd recommend creating a data model that you can use as your project evolves. Forms and queries are secondary at this point.
see the first few topics here to get an overview of normalization and entity relationship diagramming.
http://www.rogersaccesslibrary.com/forum/topic238.html