Re: Duplicating information

THanks for the info!... Was very helpful

"Douglas J. Steele" wrote:

> Something like
>
> Private Sub Textbox1_AfterUpdate()
> If Len(Me!Textbox2 & "") = 0 Then
> Me!Textbox2 = Me!Textbox1
> End If
> End Sub
>
> If you're REALLY new, to do this, look at the properties of Textbox1. Find
> the event named AfterUpdate, and select [Event Procedure] from the pull-down
> list. Click on the ellipses (...) to the right of [Event Procedure], and
> you'll be taken into the VB Editor, inside the following skeleton:
>
> Private Sub Textbox1_AfterUpdate()
>
> End Sub
>
> Type the other three lines, and you're done.
>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "sungrafix" <sungrafix@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:E188293C-E097-41E6-8F1E-AD35B08136AA@xxxxxxxxxxxxxxxx
> >I am new at this so I guess I need to see an example of the event that you
> > have discribed if that is possible.
> >
> > "Douglas J. Steele" wrote:
> >
> >> In the AfterUpdate event of textbox 1, check whether textbox 2 has any
> >> contents, and update it to the same as textbox 1 if it doesn't.
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no e-mails, please!)
> >>
> >>
> >>
> >> "sungrafix" <sungrafix@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:E316603E-1F3B-4C61-B1DD-3AD73AD5FF5D@xxxxxxxxxxxxxxxx
> >> > Is there an easy way to duplicate entered information in a form while
> >> > it's
> >> > being entered (i.e. Billing information similar to Shipping informaion)
> >> > but
> >> > have the availablity to change either without affecting the other.
> >> >
> >> > Thanks in advance!
> >> >
> >> > Ray
> >> >
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Hyperlink question
    ... Doug Steele, Microsoft Access MVP ... Private Sub Detail_Format ... If Len(Dir(HyperlinkPart(Me.Scanned_JE_Link, acAddress))) = 0 Then ...
    (microsoft.public.access.forms)
  • Re: Hyperlink question
    ... Doug Steele, Microsoft Access MVP ... Private Sub Detail_Format ... If Len(Dir(HyperlinkPart(Me.Scanned_JE_Link, acAddress), acDirectory)) ...
    (microsoft.public.access.forms)
  • Re: Understandable documentation regarding Access DBA security
    ... Private Sub Form_BeforeUpdate ... ' Set bound controls to system date and time and current user name. ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: Inserting text into multiple records selected in a listbox
    ... Doug Steele, Microsoft Access MVP ... Private Sub Command4_Click ... For Each varEntry In Me!List5.ItemsSelected ...
    (microsoft.public.access.forms)
  • Re: How to cut/append data from one field to another
    ... Doug Steele, Microsoft Access MVP ... Private Sub TransferComment_Click ... Doug Steele suggests using vbCrLf. ... there is a way to capture the name of the person logging in to ...
    (microsoft.public.access.forms)