Copy textbox to textbox from query

[zduffy]

I will attempt to explain this the best I can, so bear with me! Thanks!



I have a form that pulls data from a query, and on the form I have a text box (Me.Phone) and every record has this text box. What I am wanting to do is copy this text box though out all the records. (I have it filtered to, two records and want the data copied to both text boxes)

I have tried doing Me.Phone.Value = Me.Phone.Value (but obviously this is going to copy it self)

What are the names of the other text boxes after the first? Me.Phone2? Im confused.


Thank you for your time.

[June7]

There are no 'other' textboxes. This is seen when the form is in Design view. The same textbox is repeated for each record of the form. It is the SAME textbox, just displaying the data saved for each record.

What you want to automate is an update of records in table. This requires code.

Why should the same value be in every record? Sounds like duplication of data.

[zduffy]

There are no 'other' textboxes. This is seen when the form is in Design view. The same textbox is repeated for each record of the form. It is the SAME textbox, just displaying the data saved for each record.

What you want to automate is an update of records in table. This requires code.

Why should the same value be in every record? Sounds like duplication of data.

Doh. Lol! Thanks for your help. I can't believe Im not thinking here.