Without letting admin/user go to database window, I want table to be selected from a list box and viewed via a click on PreviewTable button (list box and button are done).
As you know RunSQL wouldn't work for Select queries. Do you know how to display a table directly from a form?
Dim sqlStr As String \
sqlStr = "Select * From site" | this wouldn't work
DoCmd.RunSQL sqlStr /
Teach me how it is done.