I have 3 combo boxes on a form which send the selected values to textboxes which represent the different sort orders for my report that the user can select.
Ie. textbox1-3 have the values FONID, FONDesc, FONDate, FONApp,
If I select FONID in textbox1 then I want the reports first sort field to be FONID.
Then in textbox2 I select FONApp, so the second sort criteria will be FONApp.
I then click on a command button and then the report opens.
Does anyone know how I can do this, my report is based on a query that has multiple queries within it so I don't think that sql is an option.
Ie. textbox1-3 have the values FONID, FONDesc, FONDate, FONApp,
If I select FONID in textbox1 then I want the reports first sort field to be FONID.
Then in textbox2 I select FONApp, so the second sort criteria will be FONApp.
I then click on a command button and then the report opens.
Does anyone know how I can do this, my report is based on a query that has multiple queries within it so I don't think that sql is an option.
