Can I open any record with a combo box????? 1

[chubby]

How can I open any form in my database by selecting the report by name from a combo box in a form????

 

[DougP]

You want to open a form by selecting a report in a combo box on your form.

I'm missing something.

I think you want to open another form or report by selecting it from a combo box.

Sure in the After Update event of the combo
--------------------------------------
Private Sub Combo2_AfterUpdate()
'If you have the exact spelling of the forms name you can do this trick

DoCmd.OpenForm Combo2.Text

End Sub
---------------------------

I created a Table with the exact spelling of the forms names
Then I create my combo box to look at that new table.

then I went into the After Update event of the combo and added the above code.

Now you could get fancy and get the spelling of every form in the database using VBA code

here is a snippet from Help

Sub AllOpenForms()
Dim frm As Form, ctl As Control

' Enumerate Forms collection.
For Each frm In Forms
' Print name of form.
Debug.Print frm.Name
' Enumerate Controls collection of each form.
For Each ctl In frm.Controls
' Print name of each control.
Debug.Print ">>>"; ctl.Name
Next ctl
Next frm
End Sub

And add theose names to the table


DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[chubby]

I'm sorry what I meant was how can I open any report in my database by selecting the report by name from a combo box in a form????

 

[chubby]

Thanks, I hope I can re-write this code to make it work for reports...