Open form & display query results in form

[CTQE]

Hello All,

I was wondering if its possible to open a form & display a query calculation on the form?

Here is another curve ball, the query is based on a field on the same form.

Any ideas or suggestions?

 

[Uncle Gizmo]

It would be possible, however I reckon you would have to initiate another instance of the form.

 

[Uncle Gizmo]

Garry Robinson did an article on it a while back, Microsoft Access Forms Are All Class Which also demonstrates gathering information from the same form and adding it to the next form, (I think, it was a long time ago) there was a download that went with this article, I don't know if it's still available.

 

[CTQE]

I was able to insert the qry as a subform within the form in question & that works well.

Thanks for your help!!!