Copying only a few fields from a record to a new record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have read many of the posts here and I can't find one that helps with what
we are trying to do....

We have a order entry form for a manufacturer. When we get reorders, we
want to duplicate certain fields from an old record to a new record. For
example:

The table has fields such as material, product size, imprint colors, etc -
all of which we want to copy. It also has fields such as quantity, price,
ship date, etc that we don't want to copy, we want to fill those in manually
in the new record.

I have tried the copy functions in the wizard and some of the code people
have suggested on other posts - even tried to manipluate it to work for this.
I am not knowledgeable enough.

Anyone - please help!

Thanks in advance.
 
One approach might be to add a control button to the order form that you add
code to. The code creates a new record and adds the values from the
"current" record -- you decide which values.
 
Thanks Jeff-

I was somewhat thinking that would be how I would do it - my issue is that I
am not familiar with creating code for buttons - I have used the wizards
before and tried to manipulate them a bit to do what i wanted after the
wizard was done - but to no avail.

Any tips on where I can go on the internet to learn how to write the code
for what i am trying to do?

Again - thanks for anything you can provide.
 
Adam

Actually, you might find enough by checking Access HELP and the examples
given there. You can also check the mvps.org website, or search at
Google.com.

And try doing a search on the access.gettingstarted newsgroup...

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top