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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem linking parameters

Status
Not open for further replies.

morfasie

IS-IT--Management
Mar 28, 2004
85
ZA
Hi,

I have a table with fields char, char and auto increment number. In a sub report I wan to use that auto increment number as my parameter, but cannot seem to link to it.

Can you only link to char values in sub reportS?

Thanks
 
One solution is to convert the value in main report, maybe a formula field with ToText. Link to something suitable in the subreport and recover the value in the subreport.

Note that any link you make will be set as a selection criterion in the subreport. Unwanted selections can be commented out or deleted.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Sorry I forgot you must change the type of parameter to number in the subreport for it to work. Then you can link the two together!!

Thanks all
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top