Default Value on Form

  • Thread starter Thread starter Erik
  • Start date Start date
E

Erik

I have a form named Result Entry in which I would like to
have a field default to the entry contained in the last
record of the table. Is this possible and how? Sorry for
such an open ended question but I am trying to learn
Access.
 
Erik said:
I have a form named Result Entry in which I would like to
have a field default to the entry contained in the last
record of the table. Is this possible and how? Sorry for
such an open ended question but I am trying to learn
Access.
Click to expand...

In the current session you can do something like:

Me!txtControlName.DefaultValue = """" & Me!txtControlName.Value & """"

That's 4 double quotes on either side.

If not in the current session, you'll need to look it up from the table if
it has either a timestamp or a sequential autonumber.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top