This line of code has given me the run-time error '3326': This recordset is not updatable:

me!txtVacation = me!txtVacation - num_hours.

The only problem with this is that it works perfectly on one form but when I copy the code to create a new form, this is the error I receive. Could anyone give me any suggestions on how to make this line of code work for a new form?

Recordset not updatable is usually a result of trying to update a query which is too complex. For example a query with three tables and a relationship only exists within the query. This results in the database having no real means of figuring out how to resolve relational problems.

To resolve this run the query that the form is based on and see if you can update the data in the query. If you can not you will not be able to in the form either. Play with the query until you can update it.

You could also go to the form and check the Recordset Type and change it to inconsistant updates. However this may result in some unexpected answers. Don't say I didn't warn you. ;-)

You could also read the following article that explains what makes a query not-updateable.
http://support.microsoft.com/support/kb/articles/Q148/5/81.asp?LN=EN-US&SD=gn&FR=0&qry=harness&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC