How do I display the answer to my Query in the same form?

[jayz12]

Hello the Experts,
I've created a query that will pull up records btwn 2 dates.

I then created a form[frm1] where I've inserted two unbound txt boxes, [date1] & [date2]. The query will refer to these fields eg.[forms]![frm1][date1] etc
when i enter in the dates and hit a button, I want the results to be displayed in the same form[frm1]based on my query.
Any help would be much appreciated.

 

[WildHare]

Place a subform control on your form, and set its record source to your query. After the query is run, the result datasheet will show up on your form.

Remember, you're unique - just like everyone else
You're invited to visit another free Access forum:

http://www.forumco.com/jmhare

or my site,

http://www.jmhare.com

 

[Jayz]

Thanks Jim,

I knew it had to be something as simple as that.

much appreciated.

Jay