Name of table and query to be more understandable

[Frank Situmorang]

Hello,

I will try to make a form and to have a procedure to export and import
contents of the table or query.

There will be a combo box to choose the table or query to export. How can I
make it when they choose it by combo, the name of the query will be more
understandable.

Thanks for any help.

 

[Keith Wilby]

Hello,

I will try to make a form and to have a procedure to export and import
contents of the table or query.

There will be a combo box to choose the table or query to export. How can
I
make it when they choose it by combo, the name of the query will be more
understandable.

Store your object names in a table with two fields, one for the actual name
and one for the description. Your combo box with a column count of 2 can be
based on this table, setting the Column(0) width to zero.

Your users will then see only the description but your combo box bounds
field will be the name.

HTH - Keith.
www.keithwilby.co.uk