Text Box Value without " " while calling a function (1 Viewer)
- Thread starter Ksabai
- Start date
- Local time
- Tomorrow, 01:12
- Joined
- Jan 20, 2009
- Messages
- 12,851
I expect you are trying to pass the name of a listbox referred to in Me.txt_Attach then use the value in that listbox inside your function.
The Eval() function can be used for this. Apply it to the parameter inside the function.
The Eval() function can be used for this. Apply it to the parameter inside the function.
arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 23:12
- Joined
- May 7, 2009
- Messages
- 19,230
can you send its Value. also attachments should are Variant so you must use Variant on your function/sub declaration:
Call SendCDOMail(Me.txt_To, Me.txt_Subject, Me.txt_Msg, Me.txt_Cc, Me.txt_Attach)
Public Function SendCDOMail(txt_To As String, txt_Subject As String, txt_Msg As String, txt_Cc As String, txt_Attach As Variant)
Call SendCDOMail(Me.txt_To, Me.txt_Subject, Me.txt_Msg, Me.txt_Cc, Me.txt_Attach)
Public Function SendCDOMail(txt_To As String, txt_Subject As String, txt_Msg As String, txt_Cc As String, txt_Attach As Variant)
