F
fox
I try to make a time period selection function. I use 4 combo boxes to make
the StartMonth, StartYear(Default 2005), EndMonth(Default Month(this month)),
and EndYear(Default Year(this year)). And I make a StartDate and EndDate to
store the value in the form. I make these 2 values visible to check the data.
When I run this form, it shows empty data. I need to select each combo box
(Month & Year), then it will update the value, otherwise, the value will show
#Error. Now my question is how to make it read the default data? so I just
need to change the value(For example, StartMonth) I want.
Thank you.
Fox
the StartMonth, StartYear(Default 2005), EndMonth(Default Month(this month)),
and EndYear(Default Year(this year)). And I make a StartDate and EndDate to
store the value in the form. I make these 2 values visible to check the data.
When I run this form, it shows empty data. I need to select each combo box
(Month & Year), then it will update the value, otherwise, the value will show
#Error. Now my question is how to make it read the default data? so I just
need to change the value(For example, StartMonth) I want.
Thank you.
Fox