How do I return the table structure using an SQL command in a quer

W

Wagner Mokva

In a VBA function, I need to fill a combo box with the table fields name.

Could you please help me on this?
 
J

Jeff Boyce

You've described "how" you are trying to do something.

If you'll describe "why" you want to do this, the newsgroup readers may be
able to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
M

Michel Walsh

Set the row source to the table name, and the row source type to Field List.


Hoping it may help,
Vanderghast, Access MVP
 
J

John Spencer

You do realize that a combobox can show a field list with the following
settings - no programming required.

Row Source Type: FieldList
Row Source: Name of Your Table



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Top