Hi,
I have created a parent report which is based on a standard query. In the text field of the report I specified the control source to be "userID". However, the subreport is based on a query which is dynamically generated by VBA (it uses a loop which compares as below
table A field 1 with Table B Field 1
table A field 1 with Table B field 2 etc..
Then
Table A field 2 with Table B Field 1
Table A field 2 with Table B Field 2
My question is how do I dynamically set the control source to reflect the current query?
I am also interested to know if there is a function to calculate how many field a given table has?
Thanks in advance!
I have created a parent report which is based on a standard query. In the text field of the report I specified the control source to be "userID". However, the subreport is based on a query which is dynamically generated by VBA (it uses a loop which compares as below
table A field 1 with Table B Field 1
table A field 1 with Table B field 2 etc..
Then
Table A field 2 with Table B Field 1
Table A field 2 with Table B Field 2
My question is how do I dynamically set the control source to reflect the current query?
I am also interested to know if there is a function to calculate how many field a given table has?
Thanks in advance!