default value

[Knight of Nee]

hi

how can i make a text box's default value on a form equal the value of another field on my form

thank

 

[bat17]

You could just use something like =[TheOtherControl] in its default value property. This will only update when the form is opened so it is of limited use. Otherwise, you will need to use code to poke the value where you want it. Where you need to put the code will depend on how you want the event to trigger. Your code would be something like
Me![SecondTextBox] = Me![FirstTextBox]


HTH

Peter