I have a table (tblCustomers) that contains all basic customer info. I also have a form (frmHoursEntry - created off of tblActualHours2016) that is going to be used by another user to enter actual hours used on a monthly basis for each customer's account. What I need to do is auto populate the form frmHoursEntry with a Customer Name any time a new customer is entered into tblCustomers. For example, when administration enters "John Doe" as a customer into tblCustomers, I need a new record to populate in the form frmHoursEntry for John Doe.
The reason I need this is because I've created a query that carries a rolling value of hours for each customer. The formula I used is "JanHrs: IIf(IsNull([tblActualHours2016]![Jan]),[tblProperties]![intJanHrs],[tblActualHours2016]![Jan])". In tblCustomers I have budgeted hours for each month, and in tblActualHours2016 (the table behind frmHoursEntry) I will have actual hours for each month. The idea is that no matter how long the customer has been active, I have a 12 month range of hours summing constantly.
The formula in the query works, but if there is no record in tblActualHours2016 then Access won't go find hours in tblCustomers. What I'm trying to do is eliminate double data entry from the standpoint of entering a customer in tblCustomers and on the form frmHoursEntry.
Any help is greatly appreciated!