teddie
Aug 6th, 1999, 11:34 AM
Hi, I have some user-entered strings in my selection formula which I would like to send to a text box on the report. How do I do it? Here's the code of the selection fomula:
Dim pstrUserDate1 As String
Dim pstrUserDate2 As String
pstrUserDate1 = InputBox("Enter the start date in the format MM-DD-YYYY:", "Report")
pstrUserDate2 = InputBox("Enter the end date in the format MM-DD-YYYY:",
" Report")
crpMonthlyPhoneLog.SelectionFormula = _
"{LOG.DATE_TIME} >= '" & pstrUserDate1 & "' AND " & _
"{LOG.DATE_TIME} <= '" & pstrUserDate2 & "'"
[This message has been edited by teddie (edited 08-06-1999).]
Dim pstrUserDate1 As String
Dim pstrUserDate2 As String
pstrUserDate1 = InputBox("Enter the start date in the format MM-DD-YYYY:", "Report")
pstrUserDate2 = InputBox("Enter the end date in the format MM-DD-YYYY:",
" Report")
crpMonthlyPhoneLog.SelectionFormula = _
"{LOG.DATE_TIME} >= '" & pstrUserDate1 & "' AND " & _
"{LOG.DATE_TIME} <= '" & pstrUserDate2 & "'"
[This message has been edited by teddie (edited 08-06-1999).]