[MS_AccessPros] Calculating text fields base on dropdown box

 

I have 3 textboxes that I would like to have calculated based on the selection in two drop down list. The first list would be cboYear that contains a list of years and then cboMonth which contain a list of months. The 3 text boxes are called txtTotalActive, txtTotalInactive, txtTotalClosed. The expression that supports the text boxes are as follows:

txtTotalActive = =DCount("[ApplicationID]","tblApplication","[ApplicantStatusType]='Active'")

txtTotalInactive = =DCount("[ApplicationID]","tblApplication","[ApplicantStatusType]='Inactive'")

txtTotalActive = =DCount("[ApplicationID]","tblApplication","[ApplicantStatusType]='Closed'")

I need to know how to adjust the expression to take the input in from the Month and Year dropdowns. Any ides would be greatly appreciated.

Thank you,

Art Lorenzini

Sioux Falls, SD

__._,_.___

---

Posted by: dbalorenzini@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___