Re: how to default values from last record

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 09/09/04


Date: Fri, 10 Sep 2004 00:48:16 +0800

See:
    Carry current value of a control to new records
at:
    http://www.mvps.org/access/forms/frm0012.htm

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"please help!" <anonymous@discussions.microsoft.com> wrote in message
news:006a01c4968b$eba360f0$a401280a@phx.gbl...
> Hi.  I have a form with three list boxes, and a value
> selection is made in each list box.  Then the record is
> saved and a new blank record is presented.
>
> However, I would like to default into the new record the
> values from the prior record just entered.  In fact, I
> would ideally like to default only the value from the
> first list box (as this first value does not change
> frequently, while the other two values do change every
> record).
>
> Can anyone tell me if/how this might be possible?  Many
> thanks in advance for any tips/tricks/suggestions. 


Relevant Pages