A text box value on a form controlled by two buttons on other form

[venu_resoju]

Hai Friends..


I have a form "Payroll" which contain two buttons named "PayrollbyDailyAttendance" and "PayrollbyMonthlyAttendance".I have given a code for these two buttons is as below.

Private Sub PayrollbyMonthlyAttendance_Click()
DoCmd.OpenForm "PayrollCreation", , , , , , "Monthly"
End Sub

Private Sub PayrollbyDailyAttendance_Click()
DoCmd.OpenForm "PayrollCreation", , , , , , "Daily"
EndSub

I have another form "PayrollCreation" which contain a text boxe named "txtNoofDaysWorked".
I have given the code on "PayrollCreation" onLoad event is as below

Private Sub Form_Load()
Select Case Nz(Me.OpenArgs, vbNullString)
   
 Case "Daily"
        Me.txtNoofDaysWorked.Value = DCount("[EmpID]", "Attendance", "[EmpID]='" & [cboEmpName] & "' AND [AttendanceMonth]='" & [cboMonth] & "' AND [AttendanceYear]='" & [cboYear] & "' AND [AttendanceStatus]='" & "Present" & "'")
        Me.txtNoofDaysWorked.Requery
    
Case "Monthly"
        Me.txtNoofDaysWorked.Value = 0
    
End Select
End Sub

but when I click "PayrollbyDailyAttendance" Button,

Me.txtNoofDaysWorked.Value = DCount("[EmpID]", "Attendance", "[EmpID]='" & [cboEmpName] & "' AND [AttendanceMonth]='" & [cboMonth] & "' AND [AttendanceYear]='" & [cboYear] & "' AND [AttendanceStatus]='" & "Present" & "'")
is working (I observed when clicking/changed design view to form view) but not Re-querying.


when I click "PayrollbyMonthlyAttendance" Button, "txtDaysWorked= "0" is working fine.

Please see my attached DB and get my exact problem...



Thanks in advance..

[hertfordkc]

Have you tried inserting "formname.requery" after you have created the filters you described?
You might look at the Mytestform.zip in this thread:
https://www.accessforums.net/forms/f...xes-18492.html

[venu_resoju]

I have tried like

"Forms!PayrollCreation!txtNoofDaysWorked.Requery"

and

"Forms!PayrollCreation.Requery"

but it is not working.

[hertfordkc]

I won't have my Access PC to look at your DB until late today. As a guess, copy or move the code shown to the Form OnCurrent event.
I read your first post as needing the txtnoofdaysworked for a subsequent query. If the textnoofdaysworked is the desired result, then the requery is superfluous.