Create Query From Form

[TommyC]

I am working with data that is spread over several tables and is joined by company name. I am working on a form with combo boxes where users can select fields from the various tables to view. The idea is that I can create a query based on the information selected on the form.

Because the data set is so large, I cannot create a single query that includes all the fields which links to the form. Therefore I'm trying to create a query that pulls the selected fields from the combo boxes on the form. My problem is that I cannot seem to link the field name on the query to the field name selected in the combo box.

Is this possible to do? Am I going about this the right way?

Thanks.

[This message has been edited by TommyC (edited 12-07-2001).]

[This message has been edited by TommyC (edited 12-07-2001).]

 

[Leo J]

In general Access is not very good with large sets of data. My suggestion is that you take some intermediate steps. You can use make table queries and so combine information or if your backend is a SQL server you could either write some stored procedures, or make an SQL statement in VBA and run that.

 

[TommyC]

I'm beginging to think your right. So is there any way to reference a field name from a combo box selection in a query?