How do i make a query with fields taken from a form?

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Can a query be made with the field names chosen in a dropdown box in a form?

I want to be able to run the same query over multiple different tables with
different names, but i cannot change the tables. So i want to be able to
choose the columns in a form, to be used in a query.

Thanks

Tom
 
I thought that this might be a possibilty, but how would i make a drop-down
box with the list of the fields in the table. Because the tables have
different numbers of fields and names.

Thanks
 
Set the RowSourceType of the combo box to "Field List" and the RowSource to
the name of the table.
 
Back
Top