I have looked and tried several solutions for this and cannot make any of them work.
I understand the idea that copying records is bad, but my client wants it as the input form for his assessments have 40+ fields and many of the records differ by one or two elements. Some of the fields are long text and not really suitable for putting in tables to draw on plus the dtata hasn't been entered yet (and we're out of time as he goes out on site tomorrow).
Given that MS provide a "Duplicate record" button, it would also seem not unreasonable. However, they seem to have neutered that and despite trusting everything a sper the myriad posts oj the web, it still doesn't work. Messing around with registry entries also isn't viable as two other people will have a copy of ths on their laptops and it's just not an option.
I've seen queries mentioned as being the correct way, but have been unable to select the current record to pass forward. All the VBA examples I've tried to adapt have just not worked - I'm so rusty with VBA (<10 years since I did any) that it's not going well.
I have no subtables, no incrementing, updating or whatever, I just need to reproduce the"Duplicate Record" button that my client has been using for years.
I would be extremely grateful if someone could point me to any basic resources that would help. It's getting late & my brain is getting frazzled too.
Many thanks.
I understand the idea that copying records is bad, but my client wants it as the input form for his assessments have 40+ fields and many of the records differ by one or two elements. Some of the fields are long text and not really suitable for putting in tables to draw on plus the dtata hasn't been entered yet (and we're out of time as he goes out on site tomorrow).
Given that MS provide a "Duplicate record" button, it would also seem not unreasonable. However, they seem to have neutered that and despite trusting everything a sper the myriad posts oj the web, it still doesn't work. Messing around with registry entries also isn't viable as two other people will have a copy of ths on their laptops and it's just not an option.
I've seen queries mentioned as being the correct way, but have been unable to select the current record to pass forward. All the VBA examples I've tried to adapt have just not worked - I'm so rusty with VBA (<10 years since I did any) that it's not going well.
I have no subtables, no incrementing, updating or whatever, I just need to reproduce the"Duplicate Record" button that my client has been using for years.
I would be extremely grateful if someone could point me to any basic resources that would help. It's getting late & my brain is getting frazzled too.
Many thanks.