get last value as current

[Derek]

Hi there,
I am create a form with name start time and end time 3 fileds. The name was not change every 14 record( around 14) I do not want entry name for every record.I want the last entry's name value automatically fill in the new record. Can you tell me how to do that?

Thank you!

 

[M.L. Sco Scofield]

If:
1 - You don't mind a key stroke
2 - The previous record has the information you want

Then the <ctl> key plus the <'> key will give copy the info from the previous record for the filed your cursor is in.

If you want the info automatically filled in when you go to a new record, take a look at the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;210236.

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

Hi there,
I am create a form with name start time and end time 3 fileds. The name was not change every 14 record( around 14) I do not want

entry name for every record.I want the last entry's name value automatically fill in the new record. Can you tell me how to do that?

 

[Steve S]

I was working on a very similar problem and found this solution:
=DLast("[My Field name]","My Table")

Place this expression in the Default Value Field of the Text Box o
your form.

Hope that helps.

BTW Ctrl ' - tip was good to know too.


Steve

:

 

[M.L. Sco Scofield]

The way you suggest should be OK.

However, just be careful. As with Totals queries, the First and Last domain functions can sometimes give you unexpected results.

See http://support.microsoft.com/default.aspx?scid=kb;en-us;109380 (old but still applies) and
http://support.microsoft.com/default.aspx?scid=kb;en-us;208190.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com