I also need to bring up a 3rd form from a 3rd table and be able to make updates to that table according to which project they chose.... so I don't see how I can do it with a subform.... I like the form you sent me - and it is a great idea, but I need to definitely be able to switch from one form to bring up a new one and make updates to that or bring up the 3rd form

basically they pick a customer - bring up the customers projects - then from there they can bring up one of 3 forms to make updates to 3 different tables associated with that project/customer..... that make sense?