Printable View
I want to duplicate a record then edit it before updating to my database. I'm already using DAO and SQL to populate three listboxes which I use to select the record then bind and fill the textboxes on my main form. Because my form has over 100 textboxes and two records can sometimes be identical except for a field or two, this would be the quickest way to add a new record.
I'm not sure if you can do this with bound controls...
Why don't u use DAO or better yet ADO to populate fields. That way, you will have more control; and it's simple enough to duplicate a record.
Once fields are populated . . . then what? I can't simply use the EDIT command to modify the info cause the original record would be affected. I'd want to be able to modify it on my form then upload it as a NEW entry not as an EDIT. I'm trying different things with a test database. I thought this would have been a simple VB command like DUPLICATE or something like that. :rolleyes:
This is a data base sample i just made
Set a reference to ADO 2.xxx and run the project
Hope this helps