What I want is check boxes to appear on a form with the name of the tables.

i.e. I Currently have 3 tables (there are more tables in my database but for this example I will only use 3) - MPI_CORE, MPI_IDS and REFF_DR.

I want some code to put the table names as a check box i.e.

[] MPI_CORE
[] MPI_IDS
[] REFF_DR

*please note [] = a check box

How could I do this using VBA?

Thanks in advance for your help :)

You can loop through your list of tables, and then change the labels on the text boxes as needed. Then you would need to remember those names in public or other variables, or in naming the check boxes as you create them, for any downstream processing.

You can either create and place the check boxes at runtime, or create with default information and set them to Visible = No, and then set them to Visible = Yes as you loop through the list of tables.

How much coding do you need?

mmcdonal

Look it up at: http://wrox.books24x7.com