Populate Datasheet Combo Box with Field List

  • Thread starter Thread starter DevDaniel
  • Start date Start date
D

DevDaniel

I have: A table containing fields (ID, TableName, FieldName). Some of the
fields are combo boxes.

I want: In datasheet view, when I open the combo box for FieldName, the
combo box populates with fields from the table listed in the TableName field.
 
It sounds like you are trying to do this directly in the table (using a
datasheet view). If so, stop now!

Access tables store data, Access forms (and reports) display data.

Use an Access form with two comboboxes. The first lets you select the
TableName. In the AfterUpdate of that first combobox, requery the second
combobox, which you will based on a query that points to the first to
determine TableName!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top