text box 1 same as text box 2 1

[is1ma1il]

I have two text boxes 1) Division Name 2) Organisation Name

I type into Division Name e.g. Abbott.
When I get to text box Organisation Name, I want it to show the same as Division Name unless I overtype it.

Is this Possible?

Thanks

 

[SgtJarrow]

In the OnEnter Event for the Organisation Name Box place:

If IsNull(Me![Organisation Name]) Then Me![Organisation Name] = Me![Division Name]

Shoudl do the trick. Programming isn't a profession of choice.
It's a profession of calling...
"Hey Programmer, your application broke again!"

Robert L. Johnson III, A+, Network+, MCP
robert.l.johnson.iii@citi.com

 

[petermeachem]

In textbox1 on exit, do textbox2 = textbox1 Peter Meachem
peter@accuflight.com

Support Joanna's Bikeathon

http://www.accuflight.com/blue_peter_bikeathon_2002.htm

 

[SgtJarrow]

Peter,
The only problem with your code is that every time you leave the Division Text Box, it will reset the Organisation Box to match....My string will only update the Organisation Box if it is empty....so if you enter a Division, enter the Organisation, the Organisation is update....but if you change the Organisation later, it will not revert back to the Division the next time you enter the field. Programming isn't a profession of choice.
It's a profession of calling...
"Hey Programmer, your application broke again!"

Robert L. Johnson III, A+, Network+, MCP
robert.l.johnson.iii@citi.com