Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print report based on form 1

Status
Not open for further replies.

VictoryHighway

Technical User
Mar 4, 2004
115
US
Greetings,

I have a call tracking database that has a main form that is used to log details regarding calls.

I have created a report that I want to be used only to print the current record on the current form.

Basically, I have code under a command button that passes the number of the primary key of the record to the report as the WHERE clause, and it will correctly open the report with only that one record, but only if I'm viewing a record that already exists.

If I'm entering a new record, and I try to use the print command button to open the report, all I see is the labels. The controls that show the actual data are blank, as if the record doesn't exist.

My question is, if I can't use a report to print the current record (that is still being edited), what can I use to create a printout?

Thanks in advance for any help.

--Geoffrey
 
You have to update the record source with the new information on your form. Try this just before your print statement in your command button code:
Code:
Me.Refresh

Hoc nomen meum verum non est.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top