Hey everyone,
I am creating this Expense Log Form for entering all expenses for vehicles that is owned by my company. I have an unbound combo box, which pulls the vin # from the tblVehicleInfo, and when a particular vin # is selected, it populates a list box with a history of expenses on that vehicle. So that works perfectly. On this form I need to enter a data for a new expense, such as date of expense, vendor, etc. I also need to list the services performed by vendor,so there could be more than one service per vendor, so i'm placing this on a subform.
My main problem is when i open the main form, I need to have all the fields blank and all the fields on the subform to be blank, but i still need a way to tie the subform to the main form, and have all this data populate my tables. I have two tables, tblExpenseLog and tblExpenseLogDetails. (connected by VINID) How do i do this, or does anyone have any suggestions???????? It will be much appreciated.
Please help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I am creating this Expense Log Form for entering all expenses for vehicles that is owned by my company. I have an unbound combo box, which pulls the vin # from the tblVehicleInfo, and when a particular vin # is selected, it populates a list box with a history of expenses on that vehicle. So that works perfectly. On this form I need to enter a data for a new expense, such as date of expense, vendor, etc. I also need to list the services performed by vendor,so there could be more than one service per vendor, so i'm placing this on a subform.
My main problem is when i open the main form, I need to have all the fields blank and all the fields on the subform to be blank, but i still need a way to tie the subform to the main form, and have all this data populate my tables. I have two tables, tblExpenseLog and tblExpenseLogDetails. (connected by VINID) How do i do this, or does anyone have any suggestions???????? It will be much appreciated.
Please help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
