Combo Box RowSource

  • Thread starter Thread starter Rob Renner
  • Start date Start date
R

Rob Renner

I am trying to display a list of all the databases forms
in a combobox. Unfortunatly I cannot figure out how to
display the list.

Thanks for your help.
 
-----Original Message-----
I am trying to display a list of all the databases forms
in a combobox. Unfortunatly I cannot figure out how to
display the list.

Thanks for your help.
.
Use the systems combo box wizard. In this you can select
Click to expand...
the unique table that contains the information you desire
to present in your combo box and you may display more than
one column if you desire...
 
It is probably not the most elegant solution but it works:

Public function FrmList() as string
Dim Frm as Variant
For each Frm in CurrentProject.AllForms
FrmList = FrmList & Frm.Name & ";"
Next Frm
Set Frm = Nothing
end

In the Form Load event:

Me.MyCombo.RowSourceType = "Value list"
Me.MyCombo.RowSource = FrmList()

Someone might suggest a callback function but there is no way I can
remember the format of that off the top of my head.
Cheers,
Pavel
 
Back
Top