Record Source Prompt

E

EB

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.
 
M

Marshall Barton

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
 
Top