Object doesn't accept this property or method??

[capdownlondon]

i'm getting this error^^^ i'm trying to update a textbox input in a subform from my calendar on my form. here's the code i'm using:

Private Sub Calendar0_Click()
Dim varCal As Date
varCal = Me!Calendar0.Value
Forms!RedsForm.RedsForm3.Text3 = varCal
Forms!RedsForm.RedsForm3.Text3.Requery
    
End Sub

It's probably something really simple, but i can't work it out.....

thanks
Adam

 

[capdownlondon]

sorted the problem, was calling the textbox on the subform wrong.
heres the correct code:

Private Sub Calendar0_Click()
Dim varCal As Date
varCal = Me!Calendar0.Value
Forms!RedsForm!RedsForm3.Form!Text3 = varCal
Forms!RedsForm!RedsForm3.Form!Text3.Requery

End Sub