I have a continuous subform that has a text field in it. This text field is set to ;
=DCount("[CustomerNumber]", "tblOrders", "[CustomerNumber] = 888")
The DCOUNT bit works fine!
However, for example, if there are 4 records shown in the continuous form then ALL of them have there text field updated.
I (obviously) ONLY want ONE record of the sub form updated. I.e. the record that I have just amended.
Perhaps, you have seen this issue before?