Problem Updating a subform control

[Guest]

I have a check box on a main form. I want the recordsource of a combobox in
the subform to update when someone clicks on it. Here's my code:

Private Sub Check59_Click()
Me.[Form].[Time Cards Subform].[ProjectID].Requery
End Sub

The error I get is:
Object doesn't suport this property or meathod.

Thanks in advance for any suggestions.

 

[Guest]

Try

Me.[Time Cards Subform].Form.[ProjectID].Requery

 

[Van T. Dinh]

Provide that [Time Cards Subform] is the name of the SubformCONTROL (which
can be different from the name of the Form being used as the "Subform", you
can use:

Me.[Time Cards Subform].Form![ProjectID].Requery

BTW, you should not use spaces or special characters in Table names, Field
names, Form names, Control names, etc ... They simply complicate things when
you need to write VBA code.