RST After the Query

[Daniel]

I have successfully made the query for my recordset but
what are the next steps? I want to output the list of
possible matches from the query so that the user can pick
the correct patient and proceed with that patient's
information. How do I output the values that came back
from the query to a form?

Thanks
Daniel

 

[Jen]

You can set the form's recordsource property to the sql
string, like this:

form.recordsource = strSQL

This is probably the easiest way to do it.

Regards,
Jen