Show query Result on a form

[benwo]

Hi

Does anyone know if it's possible to show the results of a query on a form? I have 4 people entering various "outcomes" into a table. There are a possible 8 different outcomes and the one i'm interested in is the "completed" outcome. I would like to be able to show on the form used to enter the data, the total number of "completes" so far

Any help would be really appreciated

Thanks

Ben

 

[jenny_gurl]

hi ben,

you could create a listbox and set its rowsource to a query which counts the records from your table where the "outcome" = "completed" or you could use DCOUNT.

Is this what you want?

 

[benwo]

Thanks, thats almost there. That basically displays the result of the last time the query run. Idealy I would like it to update automatically, do you know if thats possible?

 

[Cire]

Thanks, thats almost there. That basically displays the result of the last time the query run. Idealy I would like it to update automatically, do you know if thats possible?

you need to put a .requery in the form's on load/open code i believe. either that or on the listbox's code itself.

something like

me.listboxname = "yourqueryname"
me.listboxname.requery

not tested though..just something on top of my head