If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
PLEASE HELP: Refresh columns displayed in a report from a query ou
Hi All,
I have a report whose record source is a query, the query consists of dynamic Select and Where clause and so the columns are user driven (based on what user selects on a form) I am able to display the data to the report, however I am not able to refresh the columns in the report, For eg: My SQL is: strSQL = Select Student_Id, Student_FName, Student_LName & strSelect1 & strSelect2 & strSelect3 FROM Students_Table WHRE strWhere1, strWhere2, strWhere3 Now, I am able to display the specific columns in the query based on what users select in addition with Student_Id, Student_FName, Student_LName columns, However I am not able to do the same with the report, I am not able to display the additional columns that user selects in the form in the report (strSelect1 & strSelect2 & strSelect3) I have assigned this command to a button to generate the report: DoCmd.OpenReport "Student Report", acViewReport, , strWhere1 & strWhere2 & strWhere3 How can I resolve this? Hope I made it clear. Thanks in advance |
Thread Tools | |
Display Modes | |
|
|