I have a report which is produced when a button on a form is pressed. The report has many fields and records and i want the user to decide how to sort the report.
I have started with a combo box which has a few values in it, all spelt the same as the field headings in the query (where the report is generated from). I have tried adding the code:
Expand|Select|Wrap|Line Numbers
- [Forms]![frm FVQ main]![cboSortBy]
Expand|Select|Wrap|Line Numbers
- =[Forms]![frm FVQ main]![cboSortBy]
Expand|Select|Wrap|Line Numbers
- =[[Forms]![frm FVQ main]![cboSortBy]]
Im sure there is something simple that im missing, is there anyone who can suggest something??
I am using Access '97.