I am programming a MS access database to qualify for a program. I am having great difficulty and just started VBA classes. But still need a lot of help!
One table has qualifying data and other table will receive data entry with family income. Want to enter data in field [HHsize] on frmIEChild and enter data in fields [HIncome] & [Frequency] on subform frmHHI. Once data is entered want a function or subroutine to do the following:
If family has multiple forms of income and same frequencies, to total income.
If family has multiple forms of income and different frequencies, to annualize income (ie:weekly =income x 52, Bi-weekly=income x 26, 2x month = income x 24, monthly =income x 12) and total.
The "Qualify" button will "Lookup" or compare in frmIEGDate & frmIEG with the [HHsize] and Total income by frequency to determine if income is within limits. IF it is, then qualify as "F' or "R". If income is over limits for [HHsize], then qualify as "N"
Can you please assist me with these forms ?Application.zip