Dcount VS ????

[nat1967]

Hi group,

I have a form which is used to gives read outs to Managers. The read outs are counts of check boxes that the users check when complete.

The totals are shown in txtboxes. There are a bunch of the 'ol txtboxes!

Currently, I am using Dcount to calculate the numbers for each txtbox. This is very slow since its pulling across a network and Dcount is not the most efficient function.

Here is what I currently use:

***begin*****
tbxTestCasesExec10259 = DCount("[Executed]", "Main", "[Executed] = -1 AND [Feature] = '" & Forms!frm_uatonscreenreport!Feature1 & "'&quot
tbxPassed10259 = DCount("[Pass]", "Main", "[Pass] = -1 AND [Feature] = '" & Forms!frm_uatonscreenreport!Feature1 & "'&quot
tbxFail10259 = DCount("[Fail]", "Main", "[Fail] = -1 AND [Feature] = '" & Forms!frm_uatonscreenreport!Feature1 & "'&quot
tbxDefectOpen10259 = DCount("[Defect]", "Main", "[Feature] = '" & Forms!frm_uatonscreenreport!Feature1 & "'&quot

****end ****

I have experimented with SQL like this:

"Select Count(Acceptance) As strAccept, Count(Executed) as strExecuted From Main Where [Feature] ='" & Feature1 & "'"

This SQL statement will return the correct numbers but the only way I currently know to put the information into the textbox is to open a recordset with the SQL like this:

Set rs = db.OpenRecordset(strString)
tbxTestCasesPlan10259 = rs!strAccept

This seems like another inefficient way to doing what I need.

Can someone suggest an alternative to Dcount that would speed up my performance? and be more efficient?

any suggestions are welcome and appreciated! Have A Great Day!!!,

Nathan
Senior Test Lead