Creating a query result table displayed in the main form

[Naud]

Hi All,

Need your help as I am not good at access and desperately seeking for solution.

I am developing a training database which has training courses, participant names, training dates and cost.

I had created a query to display training courses from a range of dates. The user need to select 2 dates to display the course between those two dates.

I have no problem getting the result I want but I want the result to be displayed in the same form where the user keyed in the dates.

Currently when I run my query, a new table will be opened up to display the result.

I had tried to create a form and pulled in the query table in the same form but the result always displayed in a new window. The query table that is in my form is not updated at all.

Any help or advice.

Desperately seeking help.

Naud

 

[David Eagar]

Add the result of the search query as a subform on the form where the date range is entered

 

[Naud]

I had tried pasting the query result into my main form but each time i hit the run query button, a new result table appear.


I attached the screenshot of what I pasted on my main form.

Hope for further advice.

 

[Khalid_Afridi]

I had tried pasting the query result into my main form but each time i hit the run query button, a new result table appear.


I attached the screenshot of what I pasted on my main form.

Hope for further advice.

Dear Naud!
you have to create two text boxes on the main form to enter the two dates you want the result, then make your result query to your main-form row source, and call the criteria of your desire dates in the query i.e your text boxes field in the query. create a button on the form to refresh the form data (requery the results)

 

[carlino13]

Hello everyone.

I have a similar problem, i just want the query results to show in the same form where i put the command button but it keeps openning a new window.

I tried to drag a subform into the main form but it doesn't work, please tell me what's wrong.

The form i created is "formulario3", i added to the command button an action that opens the subform also in a new window but i don't know how to give the instruction to open within the same form.

Thanks for your help