duplicating data entry

  • Thread starter dtroupe-summit-water
  • 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?
 
J

Jonathan Parminter

-----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?
.

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

Luck
Jonathan
 
D

dtroupe

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top