Open a form from combo box selection

O

omneo

hi

ive got a table with a list of site (e.g. clinic, hospital etc).
i have a form that has a combo box that lists these site options.

When the e.g. clinic is selected from the combo box, how do i make
form (for data input) come up. And similiarly do this for the othe
selections. There will be different form (therefore table) for eac
selection.

thanks in advance
omne
 
K

Klatuu

There are a couple of places you can do this, but the code will be the same
regardless of which place you do it. One would be in the After Update event
of the combo box and the other would be in the Click event of a command
button. The difference being that in the first case, the form will open
immediately after making a selection in the combo box and in the second case,
after the command button is clicked:

DoCmd.Openform Me.Mycombobox
 
Top