Hi Experts,
I have a few tables which are all linked to a ComponentID via relationships, I use a form to add and edit records, this works nicely.
Though we have an issue that new records are very similar to old ones, so I want to be able to open a form (which is built on a query like when I edit) with an existing records information, then copy it and change a few minor details before saving as a new record,
What would be the best way of doing this? Note that the form is built from a query with table relationships
The edit command I use is;
DoCmd.OpenForm "frmComponent", , , , , acDialog, "Edit"
and the add command I use is
DoCmd.OpenForm "frmComponent", , , , acFormAdd, acDialog, "Add"
So the add command gives a form with blank fields, ideally having that but with existing records information already entered in all the fields (and a different record key) would be great, though I doubt this is possible ( ?)
Any help at all will be greatly appreciated!
I have a few tables which are all linked to a ComponentID via relationships, I use a form to add and edit records, this works nicely.
Though we have an issue that new records are very similar to old ones, so I want to be able to open a form (which is built on a query like when I edit) with an existing records information, then copy it and change a few minor details before saving as a new record,
What would be the best way of doing this? Note that the form is built from a query with table relationships
The edit command I use is;
DoCmd.OpenForm "frmComponent", , , , , acDialog, "Edit"
and the add command I use is
DoCmd.OpenForm "frmComponent", , , , acFormAdd, acDialog, "Add"
So the add command gives a form with blank fields, ideally having that but with existing records information already entered in all the fields (and a different record key) would be great, though I doubt this is possible ( ?)
Any help at all will be greatly appreciated!