RST After the Query

  • Thread starter Thread starter Daniel
  • Start date Start date
D

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
 
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
 
Back
Top