Creating a modified copy button

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I have a tabbed form with names---[Tab1], [Tab2], [Tab3].
Now most of the fields in Tab's 1,2 & 3 are from a single
table.
Here's what I would like to do: On [Tab3] I would like to
create a modified Copy Record button. What do I mean by
modified? Normally when you Copy a record it copies all
of the fields associated with that record, I don't want it
to do that.
Here is one way I thought might work: Press a button that
would first create a New Record, then take only those
values from the last viewed record that I would want it to
take and have them populate their fields in the New Record.
I am not sure if that's the proper way to do it or if it
would even work.
Does anyone have any ideas or suggestions on how to do
this?

Thanks in advance,
Ron
 
Ron,

I do something like this. What I do is copy all the
information desired to a temporary table, modify the key
fields to some temporary value (in most cases that
simply "TEMP"), then copy that information to the normal
table(s), and filter the form for the temporary
information. That last thing I do is wipeout the temporary
information in the form and require the user to enter that
information before the final record is saved to the
database. If there is anything you want to require the
user to complete then set that information in the form to
a value you would not accept in the database (i.e. Null or
0, etc.)

Hope this helps!

Kevin
 
Back
Top