Thank you. It works.
"But that is *very* easy to do ... requires virtually no change."
Could you tell me how to do that or give me some hints?
Thank you
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
"Could you tell me how to do that or give me some hints?"
Sure ...
Your Form is currently based on a table, right ?
See the steps below ... just create the SQL off of the existing table and make that the RecordSource - or same it as a Named query ... and use that query.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
you are welcome ...
mx
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Best to save the newly created query (SQL) as a saved query in the db window, then use that as the RecordSource. But either way requires no change to the Form really.