Default Value from last record in table

[Guest]

Hello,

I am trying to get a field on my form to have a default value based on what
was entered in that field on a previous occurrence (record).

I tried using DLast, but I read it was unreliable...

Does anyone have a better suggestion?

Thanks,

 

[Guest]

By the way, the field is CURRENCY.

I found here a solution for

 

[Allen Browne]

You can set the Default Value of the control as described here:
http://www.mvps.org/access/forms/frm0012.htm

Or you can use the BeforeInsert event of the form to copy all the fields
over as described here:
http://allenbrowne.com/ser-24.html

 

[Guest]

By the way, my field is CURRENCY.

I found here a solution for TEXT and COMBO BOX but not for numeric fields
and frankly I do not know how to "change" the so it will work with numeric
fields

 

[Guest]

Sorry, did not get it... how does that get the LAST record?

also your other link is the one I found to copy over the text and combo
values but how do I do it for a numeric field?

 

[Allen Browne]

The fact that this is a currency field should not pose a problem.

If "last record" means the last one you were editing/entering, the MVPS site
one will do it.

If "last record" means the last one currently in the form, however that
happens to be filtered/sorted, the one from my site will do that.

If "last record" means the highest value of the field in the table, you
could use DLookup() to read it from the table.

If "last record" means the value from a field, based on the highest value in
another field, you could use ELookup() to get it:
http://allenbrowne.com/ser-42.html

Once you have the "last record" value, you can assign the value in
Form_BeforeInsert. If you set the DefaultValue, be sure to include the extra
quotes, as in the MVPS example.