Open a form from combo box selection

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 a form (for data input) come up. And similiarly do this for the other selections. There will be different form (therefore table) for each selection.

thanks in advance
omneo

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

"omneo" wrote:


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 a
form (for data input) come up. And similiarly do this for the other
selections. There will be different form (therefore table) for each
selection.

thanks in advance
omneo


--
omneo