Error msg when creating tablename list box through query

J

jojo

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!
 
M

Marshall Barton

jojo said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top