Need to create a report based on an open form

  • Thread starter Thread starter Rich Schoenfeld
  • Start date Start date
R

Rich Schoenfeld

I want to put a button on a form that prints a report based on the
informtaion from the form.

The problem is the form is not bound to a table. The information in the
textboxes are calculated in the OnCurrent event of the form.

Is there a way to reference the open form textboxes in the report.

Thanks,
Rich
 
Just wanted to let you know that I finally solved my problem...

In the detail section of the report.

I was able to:

dim frm as object
Set frm = Forms("FormName").Form

rptTextBox = frm.txtName


Thanks Anyways,
Rich
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
Change lblHeading.Caption of report based on which form's buttonclicked 5
Form and Report Calculations slow 1
Timesheet-bind an unbound text box expression to a table 6
Report based on form value 7
Form with Custom report 2
How to apply the form filter on the report? 3
Using a form as a base for a report 4

Back
Top