G
golan
hello,i have two questions: 1) i have table tmppayment that get the data
from the form_payment. i want when the user choose the: renter_name and the
asset_name (in the form) the field pay_for (in the form) will update to the
month that he need to pay for example : last month that he pay 08/08 then he
need to 1+08/08 meaning 09/08.
2) to check in table contract if the pay_for in tmppayment is between the
range : start_contract and end_contract for example :01/08 and 31/12/08 if he
didnt to show msgbox and clean the field pay_for in the table and the form.
from the form_payment. i want when the user choose the: renter_name and the
asset_name (in the form) the field pay_for (in the form) will update to the
month that he need to pay for example : last month that he pay 08/08 then he
need to 1+08/08 meaning 09/08.
2) to check in table contract if the pay_for in tmppayment is between the
range : start_contract and end_contract for example :01/08 and 31/12/08 if he
didnt to show msgbox and clean the field pay_for in the table and the form.