I am making a software in access2003. I have a table ofname account(Sr #, Bill N

Question

I am making a software in access2003. I have a table ofname
account(Sr #, Bill No, Company_Id, PassingDate,Description, Amount, Balance) I want to add amount of each company against their bill andshow their total in balance. I have done it in the query design but problem is that how I implement it in theform. I am making a software in access2003. I have a table ofname
account(Sr #, Bill No, Company_Id, PassingDate,Description, Amount, Balance) I want to add amount of each company against their bill andshow their total in balance. I have done it in the query design but problem is that how I implement it in theform.

Explanation / Answer

Once the query is created, we need to create the form that weare going to use to apply the criteria to the query.

This form will contain the drop-down combo box with a list ofvalues that will run the query.

Choose a value from the drop down list.

Once a value is chosen from the drop down list the On_Changeevent procedure runs and the query will be executed.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.