Creating controls on fly based on a query

T

Tiziana Venturini

I have a listbox with a multiselection.

strSQLCarto = "SELECT CARTA,LAYER,CIRC FROM CARTO " & _
"WHERE CARTO.CIRC IN (" & strCriteria & ");"

strCriteria is the selected items in listbox.

This SQL statement build a query

QRYCARTO:

CARTA
LAYER
CIRC

CIVICI_TO
02_CARTA
02

CIVICI_TO
02_PLASTICA
02

CIVICI_TO
02_RRU
02



I want to create form's labels dynamically using the field LAYER of the
query.

Is it possible?

Thanks in advanced.

Tiziana Venturini
 

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

Similar Threads

Creating a Chart on form from selected data in query. 0
How to assign table name to be value of a field in a UNION query? 2
Run delete query instead of report... 4
Empty parameter in a query 0
How to Change criteria on a saved query using VBA 0
Using IN( ) function in a query 8
Multi Select list Box 2
How to ignore records with a duplicate ID based on a value 7

Top