Re: Populating the data of two Textboxes into One textbox

On 9 Jan 2006 13:26:19 -0800, "FA" <October.April@xxxxxxxxx> wrote:

>Thanks Oliver i tried it and it did not work. The reason why i am doing
>this is the value of txtbox3 is composed of the value of txtbox1 and
>txtbox2. txtbox1 and txtbox2 are on the main form and txtbox3 should
>take both values to form its field value.
>The sample value of txtbox3 of the subform Form2 would be ('value of
>txtbox1''value of txtbox2)
>
>If there is any other way of doing this please let me know.

If you set the Control Source of txtbox3 to

=[txtbox1] & [txtbox2]

you should get what you are asking for.

If you are trying to store the contents of txtbox3 into a Table field
- don't. It's redundant, it's non-atomic, and it simply should NOT
EXIST as a table field.

John W. Vinson[MVP]
.

Relevant Pages