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

trying to pass a field name as a string to a function

P: n/a
I have to pass a text field me.text8.value to a function
this contains a filename to link some tables.
such as database.mdb
have from 1 to 4 fields with names so I was trying to do this

For i = 1 To clickcounter
importfile = "Text" & 8 + i & ".Value"

function (importfile)
but the inportfile string contains text8.value
not what is in the text box text8
is this what is called a string to literal conversion or ???

not sure how to get this to work

any help would be greatly appreciated

jerry

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


P: n/a
nevermind I figured it out..

jerry
On Mon, 23 Aug 2004 15:03:42 GMT, sparks <sp****@here.com> wrote:
I have to pass a text field me.text8.value to a function
this contains a filename to link some tables.
such as database.mdb
have from 1 to 4 fields with names so I was trying to do this

For i = 1 To clickcounter
importfile = "Text" & 8 + i & ".Value"

function (importfile)
but the inportfile string contains text8.value
not what is in the text box text8
is this what is called a string to literal conversion or ???

not sure how to get this to work

any help would be greatly appreciated

jerry


Nov 13 '05 #2

P: n/a
rkc

"sparks" <sp****@here.com> wrote in message
news:3i********************************@4ax.com...
I have to pass a text field me.text8.value to a function
this contains a filename to link some tables.
such as database.mdb
have from 1 to 4 fields with names so I was trying to do this

For i = 1 To clickcounter
importfile = "Text" & 8 + i & ".Value"


Me("Text" & 8 + i).Value

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.