OpenArgs? String functions?

[Mermogoat]

Hi, first of all, when I use DoCmd.OpenReport and have a string for the OpenArgs parameter, when I try to access it on the opened report with 'Me.OpenArgs', It says it is a null expression.

Also, what are the function(s) for string manipulation? In my openArgs, I want to have multiple values separated by semi-colons, and I need to split that one string up at each of those points. Thanks

 

[PaddyIrishMan]

I can help you with your second point,
You can use the split function to split up a string.

1. Declare a variant variable: dim myVar as variant
2. Use the split Function:
myVar = Split(YourStringGoesHere, "YourDelimiterHere")

This looks like: Split("This is a string",";")

The return will be an array of items which you can loop thru.

HTH,
Patrick

 

[Mermogoat]

Thank you, the split function is exactly what I was looking for. Can anyone help me out with the OpenArgs paramater? Am I trying to access it incorrectly? I set a definite string in the OpenReport method, but when i try to access Me.OpenArgs I get null