Go to next record in a form with a subform inside

[AndyEduardo]

Thanks for your attention:

I have one form(Invoice Confirm), with a subform inside (Details). I
the form there are Invoice's Number, Costumer, ect... in the subfor
there are products sold (this in not the form which I use to make th
Invoice named Invoice Form), I use this form to confirm the product
sold. The Invoice Form has the property Data Entry settled in Yes, fo
this reason I can not see all records.

Each invoice has one detail (product) or more, never less.

Then in the form Invoice Confirm I can see all the records but there i
one condition, when the products of the invoice are confirmed (Details)
the record isn't shown (Invoice).
Imagine there is one field which I updates in this form and it field i
not shown in the Invoice Confirm when I open it again.

In the Record Source of the Invoice Confirm I wrote when this field i
null then show it, but this field belongs to the subform where
confirm each product.

The problem is as follow:

Between navigation buttoms of the form there are the number of th
current record, and its right there is the number of records.
The problem is in this count, for example: if the first invoice i hav
two products, in the second invoice I have three products, and in th
3rd I have two products, then the number of records shown in the lowe
of the form is seven not three like the amount of imvoices.

what can I do with this...

Please help me

 

[AndyEduardo]

Please help me to find a solution

Andy Eduard

 

[Ron2005]

It sounds like you have the 'subform' as a subform but NOT as a child
form.

Either make it a child form with child and parent relationships in the
data tab of the subform (This is the best, particularly if you are
going to possible add records.)

OR

make the child form have a datasource that is a query that has as
criteria, the key of the record in the parent form.

If the parent form is only showing one record at a time then the first
of these is the best solution.
Ron