I have an order entry system (Access 2003) that is a form (has customer information and record navigation in it) and a subform (for individual item orders for the customer selected in the form). The subform is for entering each item the customer is ordering per purchase order (multiple instances of subforms to one order form). The form and subform are tied to an order ID (a sequential number assigned to each new order - Link Master Field = OrderID (sequential number on form), Link Child Field = orderid (key for order item table)). When a new record is started, a blank order form with a new order ID and blank subform is displayed.
We have a new customer with requirements for a new product type. I want to know if I can alter the current system such that for this special customer a different subform is displayed than the original. This means that if "newcustomer" is selected in the form, then subform "A" is replaced with subform "B". Is this possible?