Count of records selected in a subform

[snipe]

Hey guys,

I have a form [Names] with an embedded subform [Names_sub]. The subform is lists of customers with a toggle on each record. The subform is linked to a query that is built directly on a table. The toggle is linked to "AddToList" field. The toggle changes the value to 1 or 2, 1 adds the name to the mailing list, 2 does not. I have a text box on [Names] with

 =DCount("Name","T_DreamRooms","[AddToList] = '1' AND [Salesperson] = '" & [SlspSelect] & "'")

On the AfterUpdate of the toggle, I have that DCount being requeried (sp?). All of the code is working, and the update is working. The problem is the dcount seems to be 1 less. If I select 3 names, the dcount will show 2. If I close that form (with those 3 names selected) and reopen it, it will say 3. Its like the [AddToList] value isn't changing until the next name is selected or the form closes. Is there a way to remedy this?



I have to have a count of selected records, and it has to be updated as soon as a name is selected.

I hope I gave enough info, let me know if you need more.

[June7]

Need to commit the field edit to table. Edit is committed when:

1. close form

2. move to another record

3. run code to save record

Why use DCount()? Why not Count() in a textbox of the subform header/footer section. Textbox on main form can refer to the textbox of subform.

[snipe]

Ah ok, that makes sense.

I used DCount() because I know how to. I've never even used Count() outside of the QBD grid. How would I use Count() for this?

What code would I put in the AfterUpdate to save the record? Would that be the best way to do this?

[June7]

DoCmd.RunCommand acCmdSaveRecord

Name textbox in subform header/footer tbxCount and expression in ControlSource: =Count(*)

Expression in mainform textbox: =[subformcontainername].Form.tbxCount

[snipe]

The save command worked great.

I'm confused with the Count() part. I only want to count the number of records where the toggle switch is set to "1." How do I do this with Count()?

Appreciate the help.

[June7]

The toggle switch is bound to a field with value of 1 or 2?

=Count(IIf([fieldname]=1,1))

or

=Sum(IIf([fieldname]=1,1))

[snipe]

The toggle switch is bound to a field with value of 1 or 2?

Yes.


I'll give that Count a try.