I'm working on a form with almost a hundred various fields (it's what my employer needs). He wants to be able to create new records with much of the same information as the old ones by clicking on a button that will copy the information to a new record, then clear certain specific fields (or some process that will safely create the same result). I don't need specifics on how to write the same line of code for each and every field I wish to clear, but I would like some advice on how to write either a VBA procedure or SQL update query.
Say I have a form with 5 fields: part_number, part_owner, procedure, file_name, and date.
How could I copy the record to keep the fields part_owner and procedure the same, but clear part_number, file_name, and date?
Note: All of the fields are from the same table (no, it's not normalized... I know this, it makes me sad, but it's not something I have time to do for them)
Thanks for any help!
Say I have a form with 5 fields: part_number, part_owner, procedure, file_name, and date.
How could I copy the record to keep the fields part_owner and procedure the same, but clear part_number, file_name, and date?
Note: All of the fields are from the same table (no, it's not normalized... I know this, it makes me sad, but it's not something I have time to do for them)
Thanks for any help!