this is the scenario. I have a form based on a tblBudgetHeader called frmDailyHeader. on that form I have info such as date and other daily information that is common for all the divisions that I will be entering. I also have a sub form that has information I need to enter for each individual division of the company. The sub form is linked to the header so for each day there should be a record. The sub form is datasheet. So that the person doing the data entry is entering information for each division I need the sub form to create a new record for each division and populate the sub form when a new daily entry is made. So I will have something open the form frmDailyHeader and I assume that I will put some kind of code in the on open event. But what?