lookforsmt
Registered User.
- Local time
- Today, 19:06
- Joined
- Dec 26, 2011
- Messages
- 672
HI! all
I have two tables tbl_A and tbl_B and form called frm_X which as combobox cbo_A with two details added: "Accept" and " Reject"
i want the Dcount function to check in tbl_A if the user selects cbo_A (Accept) and if the user selects in cbo_B (Reject) then it should check in tbl_B.
Below is my Dcount function. but i am not able to apply the combobox condition.
Any suggestions how to apply this same code when the user selects cbo_A or cbo_B
I have two tables tbl_A and tbl_B and form called frm_X which as combobox cbo_A with two details added: "Accept" and " Reject"
i want the Dcount function to check in tbl_A if the user selects cbo_A (Accept) and if the user selects in cbo_B (Reject) then it should check in tbl_B.
Below is my Dcount function. but i am not able to apply the combobox condition.
PHP:
If DCount("*", "[tbl_A]", "[chqbrcd] = '"& chqbrcd & "' and [Handover_date] = "& SQLDate(Handover_date)) = 0 Then
Any suggestions how to apply this same code when the user selects cbo_A or cbo_B