Passing contents of a textbox to a function

[shteev]

Hi, I have a form in Microsoft Access. There is a textbox which contains a filename, and a button which calls a VB function. i want to pass the string in the textbox to the VB function as an argument. How do I do this?

 

[Remou]

Please post some code.

 

[shteev]

The button has the following event:

On Click = ProcessTextFile(arg1)

The function ProcessTextFile() is passed a single argument when it's called. I want to pass whatever the contents of a particular text box are (let's call it TextBox1).

 

[Remou]

You should be able to use the name of the control:

= ProcessTextFile([TextBox1])