sending query results to a form

Hi all,

I have created a form that simply allows you to search for a specific record, it takes the value of what ever is entered in a search box and runs a query against that value to find the specific record.  All sounds simple to far and this query is working fine.... however, I now want to send that record information that it finds and display all the values on a pre-defined form that is already designed.... what code do I use to do this??

What code do I use to send those query results to a partiular form?

Many thanks,

LVL 10
Who is Participating?
peter57rConnect With a Mentor Commented:
You set the results form recordsource to your query.
Instead of running a query from your search form, you use the same button to open the results form.
bob_the_builderAuthor Commented:
You legend!!!

Thank you!! Simple when you know how eh.... :-)

Thanks again,

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.