duplicating data entry

  • Thread starter Thread starter dtroupe-summit-water
  • Start date Start date
D

dtroupe-summit-water

I haven't been able to find an example but what I am
trying to do is durring FORM data entry I have a field
LOCATION which is a job site address. I also have a
mailing address since some times the job address is pretty
ambiguous or doesn't really exist but most of the time my
job sites are the same as the mailing address. Therefore I
would like the ability to accept a default entry that
picks up on typing in the location address so I don't have
to type it in again. Any ideas?
 
-----Original Message-----
I haven't been able to find an example but what I am
trying to do is durring FORM data entry I have a field
LOCATION which is a job site address. I also have a
mailing address since some times the job address is pretty
ambiguous or doesn't really exist but most of the time my
job sites are the same as the mailing address. Therefore I
would like the ability to accept a default entry that
picks up on typing in the location address so I don't have
to type it in again. Any ideas?
.
Click to expand...

Private Sub txtLocation_AfterUpdate()
' check field empty
if isnull(txtMailAddress) then
' copy value
txtMailAddress=txtLocation
end if
End Sub

Luck
Jonathan
 
Not sure exactly what you mean? I tried to put this in the
default value expression builder on the properties for
MailAddress and it gave me an error?

Field Name=Location Control Source=Location, is the field
I enter data into and I would like to make the contents of
what I enter there to duplicate as default data foe field
Field Name=Mail Address Control Source=MailAddress
Not understanding where or how I would use the info you
provided for me?
 
Back
Top