[AccessD] Create Combo Box questions

[John Colby]

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>
wrote:

> 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