I have the above date entry form that is bound to a query of the table [distribution]. The Beneficiary field is a combo box. All work well, but I would like to speed up data entry by:
(1) I would like for the Beneficiary field to auto-fill with the next person that is in the combo selection list (since the list is 100's of names) which is "Betty White". I can select Betty White manually, but I would like an "On Enter" action to do the selection automatically.
(2) Once step (1) is completed I would like the "Distribution D" and the "Distribution Amount" to auto-fill with the values in the previous record -- that is 2/13/2015 and $25,000.00. I can not use a formula and an update query to calculate the values because they (in real live) are often the same, but about 25% are subjectively differ.
Thanks