List of Tables

J

Jason Rhymes

I'm trying to make a form that will show all my tables in a combo box and
allow me to pick one and use that same table in a report template I already
set up, if that makes since. Is it possible? Any place to see an example?
 
F

fredg

I'm trying to make a form that will show all my tables in a combo box and
allow me to pick one and use that same table in a report template I already
set up, if that makes since. Is it possible? Any place to see an example?
Click to expand...

As the Combo Box Rowsource:

SELECT MSysObjects.Name FROM MSysObjects WHERE
(((Left([Name],4))<>"MSys") AND ((MSysObjects.Type)=1)) ORDER BY
MSysObjects.Name;
 
J

Jason Rhymes

Thanks, that worked great but I thought it would be easy from there to pass
that to the report. I'm having problems with that. Can I get help here or do
I need to ask again in the report NG?
 
F

fredg

Thanks, that worked great but I thought it would be easy from there to pass
that to the report. I'm having problems with that. Can I get help here or do
I need to ask again in the report NG?
Click to expand...

You can ask here or in reports, but you need to give more information
than you did in your first post, as to what you want to do with the
list of tables.
 
Top