Listbox Problem with Tab Control

[darreno]

I have a form with a working list box. But when I insert that form into a tab control form, clicking the reports on the list box will give an error message. Attached is the db. Appreciate any advise on how to solve it.

 

[boblarson]

Your problem was the macro was calling the listbox instead of the report. Hopefully you can live with VBA for this because it's very easy in this case and I did it for you so you can see how it's done.

You may want to check out this page for some quick tutorials (screenshots) for some of this.

http://www.btabdevelopment.com/main/QuickTutorials/tabid/55/Default.aspx

 

[pbaldy]

You have to adjust your references to it when it's a subform:

http://www.mvps.org/access/forms/frm0031.htm

 

[WayneRyan]

Darren,

I can't help you with the Macro aspect of this, but if you use the DoubleClick
event of your listbox and put:

DoCmd.OpenReport Me.List2, acViewPreview

To me, that's better than a Macro, I don't use them.

Wayne

 

[darreno]

Thanks a Million!