view form from query

[flycold]

hi

i have a button, when pressed shows a dialogue box for input (date) when i press enter the results are shown in a datasheet.

how do i get them to show up in a designed form?

flycold

 

[dhookom]

Create a form based on the query and then open the form.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[flycold]

i have that working, thanks

how do i re-run the same query so the user can input another date and have the results displayed in the same form?

at the moment i have a command button on the form which re-runs the query, but then what

flycold

 

[dhookom]

If I understand you correctly, you have a parameter/prompt query that is the record source of your form. You can add a button on the form with code in the On Click event

   Me.Requery

Duane
MS Access MVP
Find out how to get great answers faq219-2884.