I need the form completed and a simple report done.
Estimate $60 for this project.
1. Driver, Week # and PayDate are all locked.
2. Code Category lists the tblICodeHeadings->strICodeHeadingDesc where IsACtive = True (checked)
3. Validate Amount has to be entered
4. Validate Trans Date has to be entered.
5. txtTotalDeductions = Amount sum of all items listed on subTempExpense subform.
6. txtRemaining just ignore for now.
txtRemainingAfter ignore
txtTotalDeductionsAfter ignore
7. Click Add writes the data into a record in tblTempDriverExpenses
The Description on each field shows where the field data comes from.
The record then appears in the subform subTempExpense.
8. Simple Report (Print Button)
Show records in tblTempDriverExpenses sorted by Driver Name
Criteria DriverID, Week# and Paydate shown
Top of Report show Week # 5 and Paydate: Date/Time printed
Columns
Date IcodeHeading Liters Gallons Amount