Drop down list of current tables in Access

[mikej336]

I was wondering if someone could tell me how to create a drop down list of the current tables in Access on an Access form.

Thanks

Uncle Mike

 

[Ed2020]

The following SQL statement will return all your tables excluding MSys tables:

SELECT [MSysObjects].[Name], [MSysObjects].[Type] FROM MSysObjects WHERE ((([MSysObjects].[Name]) Not Like "MSys*") And (([MSysObjects].[Type])=1)) Or ((([MSysObjects].[Name]) Not Like "MSys*") And (([MSysObjects].[Type])=6));

Ed Metcalfe.

Please do not feed the trolls.....

 

[mikej336]

Thanks Ed

Uncle Mike