Apply same value to all text boxes on form

[hlcarlin]

Hello, I have a form where I need the same number to be entered in 15+ text fields and I would like to set it up in a manner where you enter the number once in a "master" text box and then the 15+ textboxes automatically take on that value so the user only needs to enter the value once and then save the form. Would doing something like this be possible in Access?

Thank you

[alansidman]

While this appears to be an unusual request, I think that you can complete this task by employing a little bit of code

In the afterupdate event for the original text box (assume name is mytxt) enter this code:

me.txt1.value=me.mytxt.value
me.txt2.value=me.mytxt.value
.
.
.
me.txt15.value=me.mytxt.value
End Sub

each of the other 15 text boxes are named txt1, txt2.....etc

change the textbox names to your control names. I would be curious as to how you are using this and why you need to have this set up.

Alan

[hlcarlin]

Thank you very much! Solution worked perfectly!

The reason I needed to do this is that the database I am currently working on is has been designed in a poor manner and the cost/benefits of re-doing the whole thing do not suggest I should start from scratch... So I need to work around certain relationships between tables by manually inserting values into the tables.

[alansidman]

I sort of figured that was the case. Here is a link that you may want to look at regarding changing non-normalized databases to normalized. I don't know if this would apply in your case or not. Good luck

http://www.datawright.com.au/access_..._using_VBA.htm

Alan

[george.vniekerk]

How would one change the above code in the case of a form & Sub Form? I would like to assume the field entry from the form to a field in the Sub Form.

[alansidman]

Take a look at this video on how to reference subforms.

http://www.datapigtechnologies.com/f.../subform2.html

Alan