How can I display multiple choices based on combo box selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a form with a combo box for the user to select the method of sending marketing collateral to a customer. Based on the selection (i.e. E-Mail, Regular Mail) there would be several different types of collateral to be sent. I'm struggling with the best was to display the choices of collateral, (maybe checkboxes?) restricted to the original selection like "Regular Mail", and then how to store the choices in my Accounts table

Any suggestion
TIA, Nancy
 
One approach would be to place each group of check boxes on a separate page
of a tab control, with the tabs hidden (change the Style property of the tab
control to 'None') and display the relevant tab page in the AfterUpdate
event of the combo box. Something like ...

Private Sub Combo0_AfterUpdate()

Select Case Me!Combo0
Case "First Choice"
Me!TabCtl2.Value = 0
Case "Second Choice"
Me!TabCtl2.Value = 1
End Select

End Sub

--
Brendan Reynolds (MVP)

NNester said:
Hi,
I have a form with a combo box for the user to select the method of
Click to expand...
sending marketing collateral to a customer. Based on the selection (i.e.
E-Mail, Regular Mail) there would be several different types of collateral
to be sent. I'm struggling with the best was to display the choices of
collateral, (maybe checkboxes?) restricted to the original selection like
"Regular Mail", and then how to store the choices in my Accounts table.
 
Back
Top