User makes 5 choices to pinpoint form needed to review..need code

M

Mary A Perez

I have a "Plan/Product Choice" form that the user will utilize to take the
user to the "Rate" form.
I have developed combo boxes for the "Plan", "Product", "Location",
"Effective Date", and "Term Date" . The user needs to be able to choose all
5 of these to direct the user to the correct form once the command button
"Click for Contract Info" is clicked.
So, once the "Plan" is chosen, the next drop down should only have the
"Product" specific to that "Plan" as the next choice. The next drop down
will be the "Location" also specific to the "Plan" and "Product" chosen. The
"Effective" and "Term" dates should also be specific to the "PLan",
"Product", and "Location".
That way, when the user clicks the "Click for Contract Info" button, the
user is taken directly to the "Rate" form linked to those choices.
Please help. Thank you!
 
M

Marshall Barton

Mary said:
I have a "Plan/Product Choice" form that the user will utilize to take the
user to the "Rate" form.
I have developed combo boxes for the "Plan", "Product", "Location",
"Effective Date", and "Term Date" . The user needs to be able to choose all
5 of these to direct the user to the correct form once the command button
"Click for Contract Info" is clicked.
So, once the "Plan" is chosen, the next drop down should only have the
"Product" specific to that "Plan" as the next choice. The next drop down
will be the "Location" also specific to the "Plan" and "Product" chosen. The
"Effective" and "Term" dates should also be specific to the "PLan",
"Product", and "Location".
That way, when the user clicks the "Click for Contract Info" button, the
user is taken directly to the "Rate" form linked to those choices.
Click to expand...


To see how to set up dependent combo boxes, check these
articles:

http://www.mvps.org/access/forms/frm0028.htm

http://support.microsoft.com/default.aspx?scid=kb;en-us;209595

Once you have that part of the problem set up, then use the
button's Click event procedure to construct the appropriate
WhereCondition argument for the OpenForm method.

Once you get a start on those two areas, please post back
with specific questions. These newsgroups are an
inappropriate forum for detailed tutorials or How To
explanations to open ended questions.
 
Top