Hi,
I am completely new to Access. I have been asked to modify an existing form in a database. I have a form that we log hours into after a certain time and create a new record each time. I'm attempting to use macro builder (I have no VBA experience) to assign a macro to the button that will create a new record, take certain fields from the previous record and paste them into a previous hours field. I am able to use the button to create a new record, but that's as far as it goes. I attempted to use a sub-macro to reference the previous field and queries to select the previous, but that did not work. Any help is much appreciated. Thank you.
AccessN00bee