0

12 months name (12 check box) in a form. when I check a box it will store in backend access file. 1 adodc control also in this form. when click a button this form was shown. this month was store for that button like salary. example: a man paid his salary for january, february, march. I click the month button and the form show, I check three month for salary. it is store in access by adodc control. this is easy. but I want this month form will use for many control. here it use for only salary but I want it will use for, like house rent, gas bill, or other. I mean here the month form connect by adodc for only salary. If I click the house rent button It store month name for salary. because It connect for salary. how I slove it. help me please.

4
Contributors
7
Replies
8
Views
9 Years
Discussion Span
Last Post by jireh
0

Hi
Dont Update Database from the Form where the Check boxes available. Instead get the result(Which Check boxes are selected) from the Form, then Update database from the Calling Form.

0

>>you need to frame the query dynamically at truntime and execute the same as per user selection.

Please details.

0

Identify first what transaction to be done then after you have identified the transaction then replace the table where you connect with on that adodc control.

Another way to have a multiple transaction on one form is to use a tab control, in that way you can easily separate each transaction.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.