Combo Box

R

Ranjit kurian

I have three forms, i need my combo box to show all the three forms name, and
when i select the name it should open the form...
 
F

fredg

I have three forms, i need my combo box to show all the three forms name, and
when i select the name it should open the form...
Click to expand...

Just these same 3 forms? Never any others to be added later?

Set the Combo Box Rowsource Type property to Value List.
Set the Combo Box Rowsource property to
"Form1","Form2","Form3"

Code the Combo Box AfterUpdate event:
DoCmd.OpenForm Me.[ComboName]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with VBA code on command button 4
default value for combo box based on another combo box 3
Refresh combo box list 1
Combo box required 3
Can't find out how to get a pop up calendar in my forms 2
Locking/Enabling Combo Box in Form 6
Isloaded for all open forms? 7
Synchronize Combo Box and Text Box 4

Top