Opening forms with a combobox 1

[techkenny1]

Hi all,
I want to be able to open a series of forms uisng a combobox.
Could I have some help on this please.

kp

 

[dhookom]

What role do you expect the combobox should play in opening a series of forms?

Do you want the combobox to display a list of forms?

Do you want to select a value in the combobox and then open one or more forms with the same value?

Do want the form to open as soon as the combobox is updated?

Duane
Hook'D on Access
MS Access MVP

 

[techkenny1]

Hi Dhookam,
Thank you for your reply.
I would like the combo box to display a list of forms and then be able to select that form and for that form to open.

I have several forms in an accounting system,such as credits, debits, etc. Instead of using a command button to open each form, for the above to happen.

Many thanks,

KP

 

[dhookom]

I would create a table of your form names and a friendlier title to display for users. Use the table or a query based on the table as the Row Source or your combo box. The "title" field should contain the same value as the Caption property of your form.

You can then use code in the After Update event of the combobox to open the form (value of the combobox).

Duane
Hook'D on Access
MS Access MVP