Have controls null when form opens

[ppoindexter]

What is the best way to have all controls in a subform empty when form opens? The form and subform are bound.


The following:

Private Sub Form_Open(Cancel As Integer)
Me.textDate = Null
End Sub

Produced error - "cant assign a value to object"

thanks in advance

 

[macca the hacke]

try textdate.value = ""

 

[ppoindexter]

i had tried that already as well
same error
thanks for the reply

 

[macca the hacke]

Is the text box locked or not enabled?

 

[ppoindexter]

no, the text box is enabled and not locked

 

[macca the hacke]

Do you want to post a copy of the form and it's underlying table/query so I can look at

 

[macca the hacke]

Sorry, just noticed something in your original thread - surely it should read

Private Sub Form_Open(Cancel As Integer)
Me.textDate.value = Null
End Sub

(ie you are missing the .value after me.textdate)