Good afternoon, I wonder if someone out there could help please?
I am trying to copy one record from my table to a new record. I found an example on this forum in relation to another question which appeared to meet my requirements.
I want to copy a previously entered record and assign it with the next sequential issue number and allow the user to change the new record, but I want to retain the original record unaltered.
Unfortunately, when I attempt to run the code in my project, I get a Runtime Error Msg (64224).
I have attempted to fault find by substituting elements of my table into the OP’s example until it fails and I have reached the conclusion that it is tripping on my use of combo boxes that allow multiple selections.
Is there a way to adapt the code to allow for the use of these combo boxes as they are integral to how my project will work? I really don’t want to use an audit trail as it seems far too complicated.
I have attached the OP’s code with my addition of a combo box. Data is just an example, please bear in mind also, that I am a complete novice
Thank you for any help you can offer.
p.s. My table is quite large and as such, I am looking to avoid naming every field if possible
I am trying to copy one record from my table to a new record. I found an example on this forum in relation to another question which appeared to meet my requirements.
I want to copy a previously entered record and assign it with the next sequential issue number and allow the user to change the new record, but I want to retain the original record unaltered.
Unfortunately, when I attempt to run the code in my project, I get a Runtime Error Msg (64224).
I have attempted to fault find by substituting elements of my table into the OP’s example until it fails and I have reached the conclusion that it is tripping on my use of combo boxes that allow multiple selections.
Is there a way to adapt the code to allow for the use of these combo boxes as they are integral to how my project will work? I really don’t want to use an audit trail as it seems far too complicated.
I have attached the OP’s code with my addition of a combo box. Data is just an example, please bear in mind also, that I am a complete novice
Thank you for any help you can offer.
p.s. My table is quite large and as such, I am looking to avoid naming every field if possible