How to enumerate every record in the subform?

[swingingming]

On the Order form, I have a subform, OrderDetails, which contains every
item one customer orders. After the order is complete, I would like to
update the inventory amount. How can I enumerate the records in
OrderDetails subform?
Thank you.
Ming

[Ed Robichaud]

Order/Inventory is a few common database application (though one of the more
difficult to design). Check out the inventory template that ships with
Access and copy or modify a working example of what you /want.
-Ed

"swingingming" <mi******@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

On the Order form, I have a subform, OrderDetails, which contains every
item one customer orders. After the order is complete, I would like to
update the inventory amount. How can I enumerate the records in
OrderDetails subform?
Thank you.
Ming

[rkc]

swingingming wrote:

On the Order form, I have a subform, OrderDetails, which contains every
item one customer orders. After the order is complete, I would like to
update the inventory amount. How can I enumerate the records in
OrderDetails subform?
Thank you.
Ming

With Me.OrderDetails.Form.RecordsetClone
.MoveFirst
While Not .EOF
'do whatever with the current row
.MoveNext
Wend
End With

[swingingming]

Thank you rkc,
This is what I want. And the solution is so simple :)
ming
rkc wrote:

swingingming wrote:

On the Order form, I have a subform, OrderDetails, which contains every
item one customer orders. After the order is complete, I would like to
update the inventory amount. How can I enumerate the records in
OrderDetails subform?
Thank you.
Ming

With Me.OrderDetails.Form.RecordsetClone
.MoveFirst
While Not .EOF
'do whatever with the current row
.MoveNext
Wend
End With