Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto populate a field

Status
Not open for further replies.

mlongwa

IS-IT--Management
May 29, 2002
2
US
OK. I have a form that requires the user verify 2 points of data that build a unique identifier. What I would like to be able to do is have the entry from both fields auto populate the 3rd field so it can be verified.

example:

Field one = 1
Field two = 34

Auto populate field three = 1-34 (with mask) or 134

Can this be done and if so any pointers on how to go about it?

Thanks!
 
for the imput mask you'll have to play around with the number of "0" after the -

0\-000000;0; eg: 1-123456

Set the field1 and field2 properties to nothing, then in the Control Source for field3 enter =[field1] & [field2]

hth




Remember amateurs built the ark - professionals built the Titanic

[yoda]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top