I have a subform when you click on request,choose store name (safeway), click on the button on the right handside, you will see subform that has some events. Under quantity, not billable unit, not billableamount. to calculate the total at the buttom. Also, when you click on Embreimbitem, It will add separetly in Expensereimbursment amount which is in red. The problem I have is that everytime you add new record, when you get the the third or forth field, the cursor goes to the first record in the first field. I thought of every possible way but was not able to solve it. I attached the database. It was developed under 2003.
HI, this Dalia Hany. i offering this bid to restructure the sub form into a normal form. the parent form will have a list box and two buttons that opens a single form which represents a single child record. thanks