I have a form with a subform on it. The main form has a combo box which filters the data displayed on the subform. I then want to update a field on the main form with information displayed on the subform. Specifically, I have a combo box which displays class titles. After selecting a specific course, the subform displays all available class dates for the selected class. I want to select a date from below and have it automatically entered in the class date field on the main form . How can I do that without actually typing in the desired date?