Selecting Forms from a combox

[Dgavilanes]

Hi All,

I have 15 Small frms that I would like to select from a combo box.

as needed.

I have similar code to open reports, but now I is forms
So any help will be greatly appreciated.

Dennis


<code> for reports

SELECT [MSysObjects].[Name] FROM MSysObjects WHERE (Left([Name],1)<>"~") And ([MSysObjects].[Type])=-32764 ORDER BY [MSysObjects].[Name];


Dim rptname
rptname = Me![yourcomboname]
DoCmd.OpenReport rptname, acViewPreview

 

[dcx693]

What is that whole SELECT statement supposed to be doing? And what exactly is the problem you are encoutering? I'm guessing you're having trouble getting the combo box to show the 15 companies.

 

[Dgavilanes]

RE:Selecting

The code shows reports and opens it as selected.
Now I would like to do the same to open forms.

The code might be a little diferent for forms?

Which that is my question.

thanks

Dennis

 

[Dgavilanes]

Selecting forms from a cbx

Hi all'


"never mind" I figured out myself.

It works out fine now

thanks

Dennis