I thought this would be easy, but i’m getting confounded.
I have a form with a subform (the subform is based on a different table than the parent form) and the subform is designed to capture activities for a week. On the parent form there is a field, Week Ending ([W_E]) and on the Monday subform there is [MondayDate]. What I want to do is, after entering the Week Ending info, is to populate the MondayDate control in the subform. There is already code written to populate the subsequent weekdays on the subform based on the value for MondayDate.
I can reference the MondayDate field from VB: Me.MondayActivities_subform.SetFocus for example. However, there is no Intellisense option for .Value and when I try to assign it the value using, say, Me.MondayActivities_subform.SetFocus = Me.W_E, I get the annoying Object doesn’t support this property or method. This follows from not having .Value available in Intellisense.
Any suggestions? Obviously it would be a Good Thing to have the user input a date once and have the rest of the info automatically generated. BTW, I double-checked that both the W_E and MondayDate controls are set to Date/Time. Also, the subform is a Tabcontrol.
Thanks!
