DSum function issue with conditions / criteria expressions

[technocraze]

Hi community experts,

I am having an isue with Dsum function that is used to count the total number for a particular field (intake) at the textbox afterupdate event with condition/ criteria (subject). Below is the scenario in details.

What I need to do is summing the intake corresponding to what is selected from the dropdown combo box. For instance if the user choose maths in the combo box, the total no of intake should be displayed in the subject textbox as 150.

May I knw hw can that be achieved and whether I am in the correct direction? I have provided the necessary details that is required for this scenario. Tks for advice, code snippets.

Form controlSource = Registration Table

Registration Table design view
 
SerialCode        autonumber        primary key
subject             text                            
intake               number
 
 Registration Table view
 
SerialCode         Subject             Intake
1                       maths               100                        
2                       science             100        
3                       maths                 50      
4                       science               50         
5                       english              100              
 
 Form design view
 
Subject            unbounded combo box
Subject            unbounded textbox
Intake              unbounded textbox

Code

Private Sub Subject_AfterUpdate(Cancel As Integer)
Dim sum As Variant
sum = DSum("Intake", "Registration", "subject = '" & Me.ComboSubject.Column(0) & "'")
Me.Requery
 
End Sub

[NeoPa]

Your code doesn't seem to know what the control is named :
Private Sub Subject_AfterUpdate but later on :
Me.ComboSubject.Column(0)
Also, after setting up the variable Sum it doesn't seem to use it anywhere.

[technocraze]

tks for the reply. issue has been solved

Your code doesn't seem to know what the control is named :
Private Sub Subject_AfterUpdate but later on :
Me.ComboSubject.Column(0)
Also, after setting up the variable Sum it doesn't seem to use it anywhere.

[NeoPa]

You're welcome, and thanks for letting us know.