Query Results Into A Form

[k5kowboy]

I am trying to get the results of a query to show up in a form instead of in the results window. The query is run from a different form than the one I need the information pasted in. I have figured out the code to get the proper form to open up and also run the query, but I am unable to get the results of the query to display in the form. Thanks for the help.

 

[dcx693]

The easiest way to display query results in a form is to display the results as a subform on the form.

While in form design, drag the desired query from the database window right onto your form.

 

[k5kowboy]

Works great for displaying the results of the query. However, I need the information in a form so I can be able to add more information to it. Can I run a command that will copy the information from the query results and paste it in equivalent fields on a form? If so, how?

 

[bradcccs]

Use the query as the recordsource of the form. You can then construct the form as per normal.

If you wish to add / edit records via the query (or form based on query) you will have to ensure that the query you have created is an "updateable recordset".

Brad.

 

[k5kowboy]

WOW....I can't believe I overlooked the simple things like that. Was looking WAY too deep into it I guess. Thanks for the help.

 

[twaccess]

Use the query as the recordsource of the form. You can then construct the form as per normal.

If you wish to add / edit records via the query (or form based on query) you will have to ensure that the query you have created is an "updateable recordset".

Brad.

Thanks UncGizmo for the Google tip...

How do you make the query into an updateable recordset ? Is this something you do at the query level or at the form level ?