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

Passing a parameter as a form control (or not!)

P: n/a
Just looking through some of my code and wondering if there is any
benefit or not to rewriting this:

Forms!frmName.InputParameters = "@parameter1 =
[Forms]![frmSomeFormName].[IDControlName]"

into:

Forms!frmName.InputParameters = "@parameter1 = " &
Forms!frmSomeFormName.IDControlName

where in the second example I'm passing the actual value...

Thanks, lq

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Br
lauren quantrell <la*************@hotmail.com> wrote:
Just looking through some of my code and wondering if there is any
benefit or not to rewriting this:

Forms!frmName.InputParameters = "@parameter1 =
[Forms]![frmSomeFormName].[IDControlName]"

into:

Forms!frmName.InputParameters = "@parameter1 = " &
Forms!frmSomeFormName.IDControlName

where in the second example I'm passing the actual value...

Thanks, lq


Not sure.... I'd pass the value but it all depends on how Access
interprets it. If you were opening a SP in code you'd have to pass the
value....
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.