Selected Tables and Queries in Listboxes

  • Thread starter Thread starter SeRene
  • Start date Start date
S

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?!
 
Hi,

How can I display a few selected tables and queries in my
listboxes??
Click to expand...

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