I want to copy Value.text to the Subform
Named: SuBformInter where the field is: ValueR.text, but in the subform
there are three rows and in the main form the Value.text is just one.

could you help

--
Lorenzo DÃ*az
Cad Technician

On Sat, 18 Feb 2006 19:58:27 -0800, "ldiaz"
<(E-Mail Removed)> wrote:

>
>
>I want to copy Value.text to the Subform
>Named: SuBformInter where the field is: ValueR.text, but in the subform
>there are three rows and in the main form the Value.text is just one.
>
>could you help

You can't copy to the Subform, since the subform is just a window.
Data is stored in tables, not in subforms; and only one record on the
subform is "active" at any given time. You actually are asking how to
copy data into the subform's Table - not the subform itself.

Do you want to *update* three existing rows in the subform's Table? Or
add three new rows? What if there are five rows in the subform - do
you want to update only three, and if so which three? or all five?

You'll need to use an Update query to update existing rows, and an
Append query to add new ones; this query can be launched from some VBA
code.


One other possibility, which may not be what you want: if you want
Value.Text to be automatically added to ValueR.Text whenever you enter
a new record on the subform, simply include Value in the Subform's
MasterLinkField property, and ValueR in the ChildLinkField. If (as I
presume) there already is a field in these properties, just put a
semicolon and the new fieldname after it.

John W. Vinson[MVP]

Hi Jonh, you are correct, I want to Uopdate these field in the subform with
my field in the form..

could you give me a helping here please

Thanks


--
Lorenzo DÃ*az
Cad Technician


"John Vinson" wrote:

> On Sat, 18 Feb 2006 19:58:27 -0800, "ldiaz"
> <(E-Mail Removed)> wrote:
>
> >
> >
> >I want to copy Value.text to the Subform
> >Named: SuBformInter where the field is: ValueR.text, but in the subform
> >there are three rows and in the main form the Value.text is just one.
> >
> >could you help
>
> You can't copy to the Subform, since the subform is just a window.
> Data is stored in tables, not in subforms; and only one record on the
> subform is "active" at any given time. You actually are asking how to
> copy data into the subform's Table - not the subform itself.
>
> Do you want to *update* three existing rows in the subform's Table? Or
> add three new rows? What if there are five rows in the subform - do
> you want to update only three, and if so which three? or all five?
>
> You'll need to use an Update query to update existing rows, and an
> Append query to add new ones; this query can be launched from some VBA
> code.
>
>
> One other possibility, which may not be what you want: if you want
> Value.Text to be automatically added to ValueR.Text whenever you enter
> a new record on the subform, simply include Value in the Subform's
> MasterLinkField property, and ValueR in the ChildLinkField. If (as I
> presume) there already is a field in these properties, just put a
> semicolon and the new fieldname after it.
>
> John W. Vinson[MVP]
>

On Sun, 19 Feb 2006 08:51:27 -0800, "ldiaz"
<(E-Mail Removed)> wrote:

>Hi Jonh, you are correct, I want to Uopdate these field in the subform with
>my field in the form..
>
>could you give me a helping here please
>
>Thanks

Again...

YOU ARE WRONG.

You *keep* saying you want to update the field in the Subform. *You
CANNOT do this*.

A subform *does not have fields*. A subform *does not store data*.

A Table has fields - these may be displayed in controls on a Form or a
Subform, but the data *IS NOT IN THE FORM*. The data is in the Table,
and it is ONLY in the table.

Since I do not know the structure of your Table, I can't write the
update query for you, but it would be *something* like

UPDATE yourtable
SET ValueR = [Forms]![YourForm]![Value]
WHERE yourtable.IDField = [Forms]![YourForm]![IDField]

where IDfield is the field relating the main table to the related
table; it would typically be the Master/Child Link Field property of
the subform.

You could save this query as updMyUpdateQuery, and execute it from a
Macro in the Click event of the button on the mainform.

I will be out of town for a week so if you need more help please start
a new thread.
John W. Vinson[MVP]