[RESOLVED] obtaining the name of the text in textbox

Code:

---

Private Sub Test_Click()

  Dim RetVal As Long
  On Error Resume Next
 
  Dim stDocName As String
  Dim stLinkCriteria As String
  Dim tPath As String

    stDocName = "ImageToolPath form"
    DoCmd.OpenForm stDocName, , , stLinkCriteria
   
    tPath = Path1
  DoCmd.Close 
 
  RetVal = ShellExecute(0, "open", tPath & "\ImageTool.exe", "", "", 1)

End Sub

---

Hi all, upon clicking Test_Click(), another form "ImageToolPath form" will be opened. This form has a textbox by the name of Path1 whose recordsource is set to a particular table. I want to obtain the text in Path1 by using the statement in red so tat i can use it to launch my exe file in shellExecute.

However, the value of tPath is always NULL.. can anyone help me pls...?? thks

FT :)

my prob has been resolved as RobDog888 answered by query in the other post.. hence i do not need the answer to my post above as i can work it via another way..

thks