prepopulate field from previous record

[Guest]

Hello:

I have a data entry form which has a field "file date", often several
records will have the same file date to enter. I would like to set up this
field so that when I enter a record and go to the next record the file date
field is prepopulated with the file date from the previous record which could
be updated if necessary?

Any thoughts on how I might accomplish this?

 

[Rick B]

Ginny:

This is a pretty common question. In the future you might want to search
and read previous posts before adding a new thread. Here are a couple of
solutions from some previous posts...


Use the AfterUpdate event of the control to set its Default Value.

Details:

http://www.mvps.org/access/forms/frm0012.htm



An alternative approach is to use the BeforeInsert event of the form to copy
the values from the last record:

http://allenbrowne.com/ser-24.html

 

[Guest]

Anyone else have any ideas neither of these worked for the date field?

 

[Malcolm Cook]

Try the 1st approach again, but instead of
const cQuote="""" 'Thats two quotes
me!Control.DefaultValue = cQuote & me!Control.Value & cQuotetry me!Control.DefaultValue = Chr(34) & cstr(me!Control.Value) &
Chr(34)
Good luck