Auto Copy Form's Field Contents to Next Record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maurita - 23 Feb 2007 01:48 GMT

Hi, hope someone can help with a question I am having with a form. I
have a form where the user wants the previous entry automatically
entered in the new record but can change the field's record when
needed; the entry is based on a combo box.

The combo box is cboShift. I know how to write the After Update code
for date (Me.Date.DefaultValue = "#" & [Date] & "#", but not how to
base automatically filling in a field based on a combo box.

Thank you so much for your help.

Maurita Searcy

Reply to this Message

Eric Blitzer - 23 Feb 2007 02:31 GMT

To insert a value that is in the same field from the previous record
open a datasheet
Press CTRL+Apostrophe(')

I got this from a previous post by Steve Schapel

> Hi, hope someone can help with a question I am having with a form. I
> have a form where the user wants the previous entry automatically
[quoted text clipped - 8 lines]
>
> Maurita Searcy

Reply to this Message

Maurita - 23 Feb 2007 02:50 GMT

On Feb 22, 9:31�pm, Eric Blitzer
<EricBlit...@discussions.microsoft.com> wrote:

> To insert a value that is in the same field from the previous record
> open a datasheet
[quoted text clipped - 16 lines]
>
> - Show quoted text -

Thank you, I had found that too. I was also wondering whether there
is code so that the previous entry would automatically fill the combo
box with that entry for the new record.

Maurita

Reply to this Message