combo box

[kennytwk via AccessMonster.com]

hi, is it possible to use the combo box as a hyperlink?

i have 5 table , table A,B,C,D,E , everytime i chose 1 of those from the
combobox, the databasewill display in the spreadsheet i created below. can
someone tell me how create the combo box list manually(using VBA) without
using wizard. thanks

 

[Guest]

Look in the combobox class to see all the option that you can use. For
instance if I had a form named "Form1" and a combobox named "Combo0" I could
use the following code to populate it's rewsource:

Forms![Form1].Form.[Combo0].RowSourceType = "Value List"
Forms![Form1].Form.[Combo0].RowSource = "Value 1;Value 2;Value3"

Daniel