Default Value (Easy)

[nmajdan]

Quick question on setting the default value in a form.

How do I specify it to be the value in the previous record? I understand the CTR-' when in the form, but I would like for the number to already be in the new form when it is created. And then a play on that would be how do I get the value to equal the value in the previous form plus one? Thanks in advance.

 

[nmajdan]

please

 

[jmersing]

I don't know if I completely understand, but if you are just trying to display the last record on your form when opened then in the "On Open" event of your form just add

DoCmd.GoToRecord , , acLast

If you want to retrieve a value from that record and display it on a form with a new record, you could create a subform that defaults to the last record and place it on the form with the new record. Then you could manipulate the controls together.
If I'm understanding you

 

[CT Witter]

Try this MS KB Article #136127 -Fill Record w/Data from Prev. Record Automatically (95/97)

http://support.microsoft.com/default.aspx?scid=kb;en-us;136127&Product=acc

For A2k: see #210236

http://support.microsoft.com/default.aspx?scid=kb;EN-US;210236

*edit*
And for a case where you want to refer to a specific field see:

MSKB # 210504
ACC2000: Referring to a Field in the Previous Record or Next Record

http://support.microsoft.com/default.aspx?scid=kb;en-us;210504&Product=acc

HTH,
CT