Yes, but I can't recall where in the lesson. I can make it appear in listboxes for users to view, BUT how do I get it to a printed hard copy? I could use a Querry using Forms!InputF!FieldName. But I really like the vb code to use the where conditions.
Id Dim SQL as String and Dim Wh as String
do something with the input
SQL = ....
List.rowsource = SQL
Now I want that data to print a report on ReportR with these SQL and Where Conditions
Reply from Alex Hedley:
So you want a Report showing the SQL used to get the records or a Report showing the records that the SQL retrieves?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Search Seminar.