By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,659 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

Copy fields in form to populate blank record

P: 18
I have the main form where employees enter "issues". Some issues have fields that are the same. My fields are

Issue ID (auto)
Entered BY
Issue Type
Request from
Assigned to

Is there any way to have a check box next to each field and also have a copy button, that would copy and paste into a new blank form.

SUppose I want to copy product, issue type, priority, and status. I would check those boxes and hit "Copy". I need this to copy just those fields and paste them in the new blank form when a "paste" button is pressed.

Or when the "Copy" button is pressed, have it open a blank form and automatically populate the fields selected.

Thank you in advance for your help.
Oct 8 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,712
Basically, you could have a Command Button that opens the new form.

In the code it would set the relevant controls of the new form to match those of the existing form only when the associated CheckBox is set (True).
Oct 9 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.