B
bdehning
I am planning on tackling an update to my database to eliminate some manual
tasks and need some guidance on how to accomplish this.
I need to add a command button to my form to assign/adjust service. Once
selected a message appears asking the user to choose freq. of Service and
assign consultant which are fields in main form.
Freq of service needs to be an option group with choices of Monthly,
Bi-Monthly, Quarterly and Semi-Annually in main form. If the option for
quarterly is selected for example. a subform called Service Schedule appears
at the bottom of the form. This form lists 12 months of the year based up on
a field from the form called Inception Date. If the Inception Date is
10/01/04, the 12 months begin with October 2004. Top Month is always the
Inception Date month. The Month line also includes a check box and Function
field where uers can select up to 12 functions. This I assume is some sort
of lookup.
If quarterly is chosen for example then there in an x in boxes next to Oct
04, Jan 05, Apr 05 and Jul 05. Users need the ability to modify the
pre-selected choices and choose what they want and all 12 months could be
selected if monthly.
Can you help me get started with what needs to be done to accomplish this,
It sounds pretty straight forward but needs some programming help.
tasks and need some guidance on how to accomplish this.
I need to add a command button to my form to assign/adjust service. Once
selected a message appears asking the user to choose freq. of Service and
assign consultant which are fields in main form.
Freq of service needs to be an option group with choices of Monthly,
Bi-Monthly, Quarterly and Semi-Annually in main form. If the option for
quarterly is selected for example. a subform called Service Schedule appears
at the bottom of the form. This form lists 12 months of the year based up on
a field from the form called Inception Date. If the Inception Date is
10/01/04, the 12 months begin with October 2004. Top Month is always the
Inception Date month. The Month line also includes a check box and Function
field where uers can select up to 12 functions. This I assume is some sort
of lookup.
If quarterly is chosen for example then there in an x in boxes next to Oct
04, Jan 05, Apr 05 and Jul 05. Users need the ability to modify the
pre-selected choices and choose what they want and all 12 months could be
selected if monthly.
Can you help me get started with what needs to be done to accomplish this,
It sounds pretty straight forward but needs some programming help.