I have a button on a sheet that copies a record then gives the new record a new ID number plus one. It works great! The button hides when I am in a new record. If I want to add another number based on this sheet, the button is hidden. Can I Requery or save or something that would enter the new sheet I am working in and make it become the last record?
Does this make sense??? Sorry if I am confusing you. Let me know if I need more details.