Auto Copy Form's Field Contents to Next Record

[Maurita]

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

 

[Guest]

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

 

[Maurita]

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
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- Hide quoted text -

- 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