Combining combo box results to display to user

[Reppers]

Hi, I have created a number of combo boxes from which the user picks a number of different things (obviously), for example the year, the class, and the subject. Because I am creating this database to be PAINFULLY simple for the user, I would like to be able to display (above the button which opens the appropriate form) a summary of what the user has chosen - "To enter data for class 2R for Science" - but I don't know how to merge the combo box results into one. I would like this message to only be visible when all of the options have been chose.

Any help on either of these problems would be gratefully received!

Thanks in advance!

 

[pbaldy]

You could concatenate them in a textbox:

="To enter data for " & Me.ClassCombo & " for " & Me.OtherCombo

To only display it when the options are all chosen, you'd have to test them in the after update event of each, and set that textbox to visible when appropriate. I'd probably create a form level function that did that, and call it from each combo's after update event.

 

[Reppers]

"I'd probably create a form level function that did that, and call it from each combo's after update event."

Sorry to bother you again, but any chance you could elaborate?

Sorry!

 

[pbaldy]

Public Function CheckCombos()
  'Do your thing
End Function

In the after update events:

CheckCombos