Question Pass an Access field as a parameter to external report system?

[simpleton]

I have created a new Access project for creating Customer Order Notes.

From Access, I need to be able to open an external report (like .asp or Reporting Services) and use a parameter from the Access Form that I have open.

How could I pass a parameter like this to a link?

Example:
I use Access to create a new "Order Note" (OrderID:27) , and at the end.. I want to open a report that will use this new note in the parameter.
hxxp://asp_server/ordernotes/print_new_ordernote.asp?OrderID=27
or
hxxp://ssrs_server/reportserver?/MyNewOrderNoteReport&OrderID=27http://asp_server/ordernotes/print_new_ordernote.asp?OrderID=27

 

[The_Doc_Man]

In general, you probably will need to synthesize a string and use concatenation to do so. Whereas most of your string would be literal, your parameter would not be.

As a simpler example, search this forum for articles that use DLookup or several of the other domain aggregates to see you build the criterion clause for those aggregates.

 

[simpleton]

Thanks. I read some on DLookup, but I didn't really find much related to my problem.

I tried to trick my hyperlink, but it didn't work.
hxxp://asp_server/ordernotes/print_new_ordernote.asp?OrderID=[Forms]![OrderNotes_New]![ORDER_NUMBER]

So Frustrating...

 

[chergh]

It should be more like:

"hxxp://asp_server/ordernotes/print_new_ordernote.asp?OrderID=" & [Forms]![OrderNotes_New]![ORDER_NUMBER]

 

[simpleton]

Can't seem to get that to work either...