Thank you for your help. Again I am just getting back to Access and am finding the terms confusing. When I add code above and run, it still stops at Me This seems to be a sticking point I can't get around.

I am trying to get my form to autofill the values from the last record to the new record. In the form properites on the BeforeInsert, I used the following module

I have been away from VB for several years and am finding it challenging to understand. Can you all help? The other part of the code debugs. See below

I keep getting the same error when I debug this
Compile Error: Invalid use of Me Keyword
Here is...