passing parameter from forms to reports in ms access?

  • Thread starter Thread starter vikash.verma
  • Start date Start date
V

vikash.verma

Hi
I am trying to pass data from a combo box in the FORM to Reports in Ms
Access.Depending on the data choosen in the form i need to generate a
report.But i am not able to pass the data from Forms to Report dynamically.

I am new to ms access so does not know how to proceed.Any help from ur end
will be very helpful for me

Thanks
Vikash
 
The report will have to read this information by the Format event of the
section containing the reference to the form. That means the form cannot
send the value to the report, but the report can read the value from the
form.

Example:
To show the value from column 2 of the combo named "MyCombo" on "MyForm",
set the Control Source of the text box on your report to:
=[Forms]![MyForm]![MyCombo].Column(1)
 
Yaa I got it.Infact i have done it in this way

WHERE
[Driver].[Description]=[Forms]![Form_ActivityReport]![Driver_Control].[Value
] ;

Thanks for the help

Bye
Vikash



Allen Browne said:
The report will have to read this information by the Format event of the
section containing the reference to the form. That means the form cannot
send the value to the report, but the report can read the value from the
form.

Example:
To show the value from column 2 of the combo named "MyCombo" on "MyForm",
set the Control Source of the text box on your report to:
=[Forms]![MyForm]![MyCombo].Column(1)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

vikash.verma said:
Hi
I am trying to pass data from a combo box in the FORM to Reports in Ms
Access.Depending on the data choosen in the form i need to generate a
report.But i am not able to pass the data from Forms to Report dynamically.

I am new to ms access so does not know how to proceed.Any help from ur end
will be very helpful for me

Thanks
Vikash
Click to expand...
Click to expand...
 
Back
Top