How to make the cursor move automatically between records on the FORM

[VladimirKim]

Hi,
I have a subform where there are few records. After I press the button on the parent form, I need the cursor to go through all the records on the subform. Line on the button's click event: DoCmd.GoToRecord acDataForm, "Sub_Hdetails1_Quote", acNext generates an error: "Sub_Hdetails1_Quote form is not open" even though it is open, but it's a subform within a parent form "Restabs". And, also, how would I find out the number of records in the subform without creating a recordset from sql statement?
Please, help.
Thanks

 

[Remou]

Hi
I think you need to use:

DoCmd.GoToControl "Sub_Hdetails1_Quote"
DoCmd.GoToRecord , , acNext

Where Sub_Hdetails1_Quote is the name of the subform control.

 

[Remou]

Oops, as for the number of records:

intCount = Me.Sub_Hdetails1_Quote.Form.RecordsetClone.RecordCount

Where Sub_Hdetails1_Quote is the name of the subform control.