transfer data from a query

[jbm]

I would like to filter data with a query and then select one of the records from the query and transfer that record info to a form that is already opened.<br>thanks

 

[DougP]

Make a form that is attached to your query<br>like so:<br>Click the queries TAB<br>then click the &quot;Insert&quot; menu then click &quot;Autoform&quot;<br>It will make a form in a few seconds.<br><br>Next open your new form and put a Subform at the bottom.<br>Think of this subform as the new form you wanted to open from your query <br>The subforms Child/Master Link will need to be a field that matches on both forms.<br>Or you could make anther form and have a button that opens it from the first form.<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[jbm]

Doug <br>Thanks for your help. I would like one form to open the other.when I open my old form it says that this recordset is not updateable. I am sure it is something simple. Thanks<br>

 

[DougP]

Is the recordset a Query connected to more than one table???<br>then it is NOT updatable.<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.