I'm having trouble with a form. There are add/save/delete record command buttons, however when you add a record, you have to exit the form and come back in, click on the form for the assigned ID number to update...
Is there a trigger that needs to be put in the code to allow automatic updating of the record and insertion of the ID#???

You can use update and add new record using one command button. If u want to update your data to specific ID then u have to mention that in update query
for exapmple

table .products

u want to update the quantity when the user issue parts to customer .so u have to create a update query . select two tables Invoice and invoice details .

field : unitsinstock
Table : products
updateto : [products].[unitsinstock]-[invoicedetails].[qty]

Next column select InvoiceId from invoice details and select table invoicedetails.
update to : leave it blank

criteria : [FORMS]![INVOICE]![INVOICEID]

So when the user issue parts from the products table ,the qty will be updated when ever he run the update query using command button in invoice form .

If any issues pls send e-mail I will check it for you.

Regards

Anil