Help with VBA! Please!

[FlavioT]

Hi

What I'm trying to do must be very simple...

I have a continuous form and I'd like to put in fild IDCaixa the same value in the head of the Principal form...

What I wrote was:

Private Sub Comando14_Click()
For Each Record In Form
Me.IDCaixa = Forms!CaixaCC!IDCaixa
Next
End Sub

But this command line just adds in the first line the value I want... how to put this values in all the recordsets at once?!

Thanks a lot!!

 

[ChrisUK]

why not use some SQL and an update command ?