Selected Tables and Queries in Listboxes

[SeRene]

Hi,

How can I display a few selected tables and queries in my
listboxes??
I have two listboxes, one is for displaying selected
tables, the other is for displaying selected queries.
I was given this method to be pasted under the field row
of the query which i want to display in my query
listbox --> Display: IIf(Left([Name], 4) = "qry_",
[Name],"") and set the criteria row to --> <>"" and yar, i
have to rename those queries which i want to display
with "qry_" in front.
However, this method isnt working. Did i go wrong
somewhere?!

 

[John Vinson]

Hi,

How can I display a few selected tables and queries in my
listboxes??

Just create a table with a text field; maintain your own list of
tables and queries.

Note that most developers will avoid even letting users SEE table
datasheets, much less present them for selection! Use Forms instead.