Default Value on Form

[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.

 

[Arvin Meyer]

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.

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