Combo Box RowSource

[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.

 

[hansford cornett]

-----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

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...

 

[Pavel Romashkin]

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