I have a form frmAnnual with a primary key of AutoNumber. On this form is a subform frmCustAnnual, which draws from the same source table: Annual. The subform is acting as a menu of all the entries for a selected customer (selected from a combo on frmAnnual). I want to be able to click on a particular record on the subform and have it, and only it populate the main form.
Is this possible??? I need to get this done ASAP. Any help is appreciated!