.requery with sub form

[Gianluca_Venezia]

Scenary:
a main form contains two sub-form unbounded.
Sub-form "one" contains a list of products.
Sub-form "two" contains the items of the selected product.

Event:
when, from sub-form "two", it's modified type or quantity of items, I
need to execute .requery's method on sub-form "one";

Problem:
..requery's method on sub-form "one", sometimes, relists the records of
that form and changes view order; when it happened, the focus from the
selected record of sub-form "one" moves to others, and that fact make
not usable the form.

"negative" example:
sub-form "one" - inserted record "1"
sub-form "one" - inserted record "2"
sub-form "one" - inserted record "3"
sub-form "two" - modifying items
*** problem:

sub-form "one" - focus on record "2" (last position)
sub-form "one" - record 3 moved in first position

I'm not able to understand why this problem happend often and not
always, and that problem so described it's difficult to be correctly
focalized.

Some ideas about?

Bye, Gianluca

[Arno R]

Gianluca,

You need to 'link' the two subforms. There will be no need to requery form 'one'.
Access can do this for you ...
I think you need something like the Form 'Customers and Orders' in the sample
Northwind.mdb
Check it out.

--
Hope this helps
Arno R

"Gianluca_Venezia" <te************@yahoo.it> schreef in bericht
news:11**********************@g14g2000cwa.googlegr oups.com...

Scenary:
a main form contains two sub-form unbounded.
Sub-form "one" contains a list of products.
Sub-form "two" contains the items of the selected product.

Event:
when, from sub-form "two", it's modified type or quantity of items, I
need to execute .requery's method on sub-form "one";

Problem:
.requery's method on sub-form "one", sometimes, relists the records of
that form and changes view order; when it happened, the focus from the
selected record of sub-form "one" moves to others, and that fact make
not usable the form.

"negative" example:
sub-form "one" - inserted record "1"
sub-form "one" - inserted record "2"
sub-form "one" - inserted record "3"
sub-form "two" - modifying items
*** problem:

sub-form "one" - focus on record "2" (last position)
sub-form "one" - record 3 moved in first position

I'm not able to understand why this problem happend often and not
always, and that problem so described it's difficult to be correctly
focalized.

Some ideas about?

Bye, Gianluca

[Gianluca_Venezia]

thw two subform can be linked? Never Tryed... I always use to link main
form with a subform...

however, I solved so:

parent.formone.form.refresh
and run well.

thanks
Gianluca