Duplicate form after selecting value from combobox

[meatpie579]

Hello,

I'm pretty new to Access 2007.



I have a form and in it there are data entry records including a combobox.

I'd like to select a value from the combobox, say "1" and when I do I would like all the information on that form to be duplicated in a new form.

I'd also like a message to pop up saying that info has been duplicated and that the user must update some of the fields.

Thanks for your help!

Meatpie579

[RuralGuy]

You do understand that Forms are simply windows into tables don't you?