Combo Box

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am new at this and not exactly sure how to accomplish
what I need. I have created a combo box(called
cboOptions). I have also created a subform on the page.
Whenever a user selects a option in the combo box, I
would like the subform to change to match their choice.
I have created all the necessary subforms (for instance,
sbfrm_OpenIndRec, sbfrm_printdaterange, etc...) Each of
the subforms will have different text boxes associated
with it.
From a previous post, it was suggested to use Select
Case. That did not seem to work for me. I am sure I did
something wrong.
I would be most appreciative if someone could point me in
the right direction on this.
 
I am new at this and not exactly sure how to accomplish
what I need. I have created a combo box(called
cboOptions). I have also created a subform on the page.
Whenever a user selects a option in the combo box, I
would like the subform to change to match their choice.
Click to expand...

You can leave the Control Source of the combo blank, and put the *name
of the combo box* into the subform's Master Link Field property. This
isn't an option the subform wizard will offer you but you can just
type it in. Make sure that the bound column of the combo box refers to
the field you want to use as the link.
 
Back
Top