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

OpenArgs format question

Abhean
P: 28
I am using openargs to transfer 2 variables to a form. However I am missing something when I sent the request through.
The second variable goes through without problem, but the first one is not. The system is seeing the Var name and sending that. Im sure it is just a formatting problem.

Code in Parent I Need it to pull the variable Accessionz and ClientNumz. The Bar is the separator.

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "FollowUpFrm", , , , , , "Accessionz|" & ClientNumz
2 Weeks Ago #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,761
Abhean.
You're passing the name of the variable as a string. Why would you expect anything other than that name to be received by the Form. If you pass the value instead then you'll get the value that I assume you want.
2 Weeks Ago #2

Abhean
P: 28
and I hate parenthesis!
Move one and it works.
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "FollowUpFrm", , , , , , Accessionz & "|" & ClientNumz
2 Weeks Ago #3

NeoPa
Expert Mod 15k+
P: 31,761
I'm not sure I follow the bit about parentheses. There is none in your code. However, you have moved the word Accessionz such that it is no longer within the quotes ("), just as I advised, so I'm glad to hear it works. Within quotes means it is a literal text string whereas outside of them means it's used to point to some object or variable as a reference. It certainly should work like that.
2 Weeks Ago #4

Post your reply

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