I am working on a form with a combo box that contains a Customer ID (which is also the Lot#) and property address.  I have based by Combo Box on a "Cust Add Query" that lists the Customer ID and property address. My combo box shows the Customer ID and property address however I cannot get it to auto-fill the address or lot number into the appropriate fields when the Customer ID (Primary Key) is selected. Perhaps there is a command or VBA that this needs but I am lost on where to go from here.  Is there a way to accomplish this functionality?