Load 'Directory' into TextBox

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

ryguy7272

I’m using the code from here:
http://www.mvps.org/access/api/api0002.htm

Works great! Now, I named a TextBox ‘Att’ (for an attachment) and tried to
get Directory name into my Att (TextBox).

I am trying to run this code:
Private Sub Command17_Click()
Dim strFolderName As String
strFolderName = BrowseFolder("What Folder you want to select?")
.FormFields("Att").Result = Forms!frmMail.strFolderName
End Sub

Something isn’t working right. I get an error here:
..FormFields("Att").Result = Forms!frmMail.strFolderName

Error Message is: Compile Error – Invalid or unqualified reference


I changed that one line of code to this:
..TextBox("Att").Result = Forms!frmMail.strFolderName

Still receive the same message.

What am I doing wrong?


Thanks,
Ryan---
 
Change this code line:
.FormFields("Att").Result = Forms!frmMail.strFolderName

to this:
Me.Att.Value = strFolderName
 
Brilliant!!! My interest in Access appreciates every single day!!
Thanks so much Ken!
Ryan---
 
Back
Top