[AccessD] Create Combo Box questions

John Colby jwcolby at gmail.com
Tue Aug 23 11:45:47 CDT 2022

There are two collections with different syntaxes which display the open
tables and all tables.  As for the fields, everything in access has
collections of... whatever is appropriate.  Tables have a collection of
fields (and indexes I believe).  Fields have a collection of properties.
Actually everything in access has a collection of properties.  Etc.

You will find all of this in the editor window.  Dimension tbl as
Tabledef.  Then look at the tabledef properties looking for a fields
collection.  That will have a collection of properties, one of which will
be the field name.

Or google it.  Google is your friend.

On Tue, Aug 23, 2022 at 10:06 AM Arthur Fuller <fuller.artful at gmail.com>

> I want to create two Combo Boxes, or use the built-ins. I want one to
> display a list of tables in the current database, while the other displays
> the list of fields available in a given table.
> While I'm at it, I would also like to create equivalent combos which list
> the forms, reports and queries in the current database as well
> Any suggestions?
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

John W. Colby
Colby Consulting

More information about the AccessD mailing list