Error msg when creating tablename list box through query

[Guest]

I created a query to list all my tables (thanks to another users post):

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "msys" & "*") AND ((MSysObjects.Type)=1));

But when I try creating a list box through the (by using the list box
wizard) from that query I am getting an error msg: No value fields can be
found in 'tablename_qry'. Please select a new source. Please help on how I
can create a list box naming all my table names. Thanks!

 

[Marshall Barton]

I created a query to list all my tables (thanks to another users post):

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "msys" & "*") AND ((MSysObjects.Type)=1));

But when I try creating a list box through the (by using the list box
wizard) from that query I am getting an error msg: No value fields can be
found in 'tablename_qry'. Please select a new source.

I suspec that the wizard is deficient for such a simple
list. Try creating the list box from the toolbox and
setting its RecordSource property to your query.