DCount Causing Form to Stall

[Zerdan]

I've got a form that allows a user to enter search parameters and then click "search" which opens a second form to display the results of a query based on the search parameters. In the header of the results form I want a text box called total results that contains the number of results of the query.



I've tried to do this with DCount("*", "Query Name") and when I open the form it says "Calculating..." in the lower left and just stalls out.

I'm thinking maybe I need to calculate the total with the parameters that were used to search (but then how do I pass that number to my textbox?)

Or maybe I can recalculate some other way on the form, but I can't get it to work without stalling on the Calculating...

Thanks.

[NoellaG]

Hi,

there are several options you can use like using the .recordcount property of the forms recordset clone.
But if you want to do it with a Dcount and without any VBA code, I would suggest you use the where clause in the DCount function to repeat the selection criteria; example:

DCount("*", "Tablename","Field1 = " & Forms![FormName]![Name CritField1])

assuming Field1 is a numeric field, of course

Hope this helps
NG

[Zerdan]

Thanks for the info. Recordcount sounds like the way I want to do it reading into it a little bit more. A couple questions about that...

How do I set my RecordSet? Right now I'm just passing my parameters from the search form to DoCmd.OpenForm and then running my query from there and populating the Results Forms with the filtered results.

Once I have my RecordSet established, where do I put the code...like what should my Private Sub be named? Sorry for the questions, I am new to VB.