Record Source Prompt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that is designed to accept multiple tables as the underlying data source. Can I prompt the user to enter (or chose) the record source upon opening the report.
 
EB said:
I have a report that is designed to accept multiple tables as the underlying data source. Can I prompt the user to enter (or chose) the record source upon opening the report.
Click to expand...


This sounds like a symptom of a deeper problem, but Yes you
can use the report's Open event to do that.

Dim strSource As String
strSource = InputBox("enter table or query")
If strSource <> "" Then
Me.RecordSource = strSource
Else
Cancel = True
End If
 
Back
Top