i have created a new query and run the query and the result came out. However, i would like the results from the query to be displayed in a form. I have created the form. May i know how do i link the query to be displayed in the form?
i have created a new query and run the query and the result came out. However, i would like the results from the query to be displayed in a form. I have created the form. May i know how do i link the query to be displayed in the form?
Use the query as the forms Record Source property
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
The record source is already linked to query. The control source is only following the name.
I don't understand this.The control source is only following the name.
The control source of WHAT is only following the name of WHAT.
What do you mean by "following".
If you have a query set as the forms' Record Source then you will be able to have a control on the form that is bound to each field in the query using the controls' Control Source property. This will show the results of the query on a form which is what you said you wanted in post #1
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick