Error msg when creating tablename list box through query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
Click to expand...


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.
 
Back
Top