Browse records of subform from main form

[capsula4]

Hello helpful friends!!



Does anyone know now how to make Cmd functions work on subforms? I kinda want to make a massive paste on a field of a subform, so what I'm doing is kinda like this:


Code:
DoCmd.GotoRecord,, acLast
LastRec = CurrentRecord 'get position of last rec
DoCmd.GotoRecord,, acFirst 'start pasting from first rec
Do Until (CurrentRecord=LastRec)
[Details].Form![FieldToBePasted]=Me![FieldWithInfo]
DoCmd.GoToRecord , , acNext
Loop

Tho, all the DoCmd should be refering to the [Details].Form which is the subform, since what this makes is to make a massive paste on the subform...

Thanks in advance!
Luis

 

[KenHigg]

Something tells me you should look into using dao recordsets to do this -

 

[capsula4]

Thanks!!

I could make it by using the following code:

Dim rs As DAO.Recordset
Set rs = [Details].Form.Recordset
rs.MoveFirst
Do until rs.eof
[Details].Form![FieldToBePasted]=Me![FieldWithInfo]
rs.MoveNext
Loop

Thanks a lot Ken for the help!

 

[KenHigg]

Glad to help