Pasting info

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

Guest

I've been assigned to create a database managing over 150,000 pieces of
information. It's a good thing I found out what code was last week. I
definitely need a paste option. Currently I'm trying to copy data enterred
from a form that has been saved and is still showing on the current form to
be set as the default for the new record called up. I need to do this with a
command button. The majority of the form has default values already set for
new records, and the info I want to hold over for the new form are mainly
selected from drop down menus. I only need to do this with a couple of
values. My girlfriend's a witch and so I'll try to have her cast good magic
on anyone that can help!
 
This will take some VBA coding, but can be done.
Use the form's Before Update event to copy the current values of the
controls you want carried over to the controls' Tag property. Then when you
create a new record, use the form's Current event to assign the value in the
Tag property to the control:

Before Update:

Me.SomeTextBox.Tag = Me.SomeTextBox
etc.

Current Event:

If Me.NewRecord Then
Me.SomeTextBox = Me.SomeTextBox.Tag
etc.
End If

Tell your girlfriend I'd like a Hummer - Black, please.
 
uh oh my girl friend said and I quote:

" but sure, let me just reach back here and (mmmrrrppphhh) pull that black
hummer for some guy i don't even know (arrrrrrghhh) right out of (eeerrrrgh)
MY ASS!!! how's THAT for magick?!"

Did I say she say was a witch? I guess she's really just a bi...OUCH!!!
 
Back
Top