Duplicate data on a form & subform

[tomco22]

I have an [Orders] form that contains an [OrderDetails] subform. From time to time we need to re-order the exact same items from the same vendor. Is there an easy way to duplicate all the data on the form & subform but with a new order number and new order date? tomco22
tbrashier@vectormachinery.com

 

[Bernadette]

Hi There

What you need to do is carry the current value of the control forward if you place this code behind a command button to conditionally run it. It will set the current values to the default values of your records so the same data will pop up when you need new order details.

const cQuote="""" 'Thats two quotes
me!Control.DefaultValue = cQuote & me!Control.Value & cQuote


Hope this helps

Bernadette

 

[tomco22]

Hey Bernadette,

I put this code snippet behind a command button but it growled at me. Should this code do the job on its own or is there some other minor details that you assumed I would know about. Maybe you assumed that since I could type sentences that I must be somewhat intelligent. Wrong! Anyway, do you have further suggestions?

Tom tomco22
tbrashier@vectormachinery.com