The Calendar database I created is for a mobile notary that closes real estate transactions so depending on whether the transaction is a purchase or refinance there can be 1 (borrower) or 2 (buyer and seller) customers. Can you point me in the direction of how I could make my form have 1 or 2 customer subforms depending on the transaction type selected in the master form. In other words can a subform be conditionally turned on or off in a master form?
Reply from Richard Rost:
Sure... you could just set up two subforms and set the VISIBLE property to YES or NO accordingly... OR change the source property of the subform to whatever actual FORM you want to use. There are a lot of ways to do it.