Data doesnt show on Report

[JennieFernandes]

I have a report being called for from a form. In the form, when the user clicks on the command button, the report will open and a visual basic code generates the values for all the text boxes in the report.

When I click on the command button in the form, the report opens up blank. When I switch from preview to design view of the report and back to the preview mode of the report, all the values can be seen in the report. How do I ensure that the values show up on the report without me having to switch between design view and preview mode.

Jennie

 

[GingerR]

what is the code for the form's button's OnClick event? What is the code for the report?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[JennieFernandes]

The code for the forms command button (OnClick event) generates the values for the report. So there is no two sets of code. It is just one. If you would like, I can attach the code but all it does is, it pulls values from tables and puts it in the report in a specific format.

 

[GingerR]

Please post your code. Thanks.
Does your report have a recordsource?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html