get last value as current

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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

Derek said:
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
Click to expand...
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?
 
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

:
 
Back
Top