Making the ComboBox do more.... 1

[tdbeargrrl]

When the user makes a selection in the combo box in addition to populating that field in the table a second form (not a sub form - a second small form) should open. Is there anyway I could make this happen?

 

[papparuff]

In the Combobox's After Update event you could add the following:

DoCmd.OpenForm "YourFormName" John Ruff - The Eternal Optimist

 

[tdbeargrrl]

Can this solution be expanded to open a different form depending on which choice was selected in the combo box.

IE - Third Party Lien opens one form; Overpayment opens a different one.

Thanks

 

[jebry]

Hi!

Use a Select statement:

Select Case YourComboBox.Value
Case "Third Party Lien"
DoCmd.OpenForm "LienForm"
Case "Overpayment"
DoCmd.OpenForm "OverPayment"
etc.
End Select

Of course, you will need to use the actual form names and field values that exist in your database. Note, the value of the combo box comes from the bound column so you will need to do the select statement on the column you chose as the bound column.

hth
Jeff Bridgham
bridgham@purdue.edu