By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Sub Form in a Report

P: 15
I have a report in which i am trying to include a sub form. The Sub form is already there and it is used in another form also.

The subform's RecordSource points to a SQL Server stored procedure,
Expand|Select|Wrap|Line Numbers
  1. exec sproc_MOR_Tickets 1855
Now, when the report is opened, i have a value which i need to set in the place of 1855. But when i tried to refer to the subform like this:

Expand|Select|Wrap|Line Numbers
  1. Reports![rptMORTradeCaptureReview]![SubFormMORTickets].Form![TradeRef].DefaultValue = strTradeRef
I get a error.

Expand|Select|Wrap|Line Numbers
  1. Run time error: 2455
  2. You entered a expression that has a invalid reference to a form/report
I am new to access !!! So if you guys can tell me where i am missing out, it would be very helpful. Thanks in advance.
Oct 13 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.