UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> preview report from form based on text box    
 
   
jamborrs
post Mar 22 2006, 10:43 AM
Post #1

UtterAccess Addict
Posts: 131
From: Toledo, OH
Hi,
I have a form (frmCustomer) with a subform (frmJobsSubform). From the subform, I have command buttons that allow the user to preview or print an invoice and a proposal. The proposal report is based on qryProposalData, in which the criteria of Job ID is set to [Forms]![frmCustomer]![frmJobsSubform]![JobID]. It is opened in dialog view, only when the form is opened. This has been working correctly for weeks now, and today when I tried it on another computer, with the same version of Access, the report displays no data. I know it has to do with passing the jobID in the query to the report, because if I open the report from the database window (and just type a Job ID when prompted), it works fine.
Is there a better way to accomplish what I am doing here? I can't figure out why it doesn't work now since it did in the past.
Thanks in advance,
RSJ
Go to the top of the page
 
+
merlicky
post Mar 22 2006, 01:36 PM
Post #2

UtterAccess Addict
Posts: 176
From: Kalamazoo
Try setting the Job ID to:
Forms![frmCustomer]![frmJobsSubform].Form.[JobID]
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 06:14 PM