Default a Form to Last Entry

  • Thread starter Thread starter jmcurl
  • Start date Start date
J

jmcurl

I've been searching this group for ways to do this and there are many
posts saying I need to use the control's AfterUpdate to set its own
DefaultValue property.

Here is the code I'm trying to use:

Me.Clock Number.DefaultValue = """" & Me.Clock Number & """"

The Clock Number is the name of the Text Box I want to default.

When I run the form and try to enter a clock number I get the following
Error:

Can't find the macro 'Me.'

I've learned a lot about Access in the past two weeks on this project,
but this has me stumped and the due date was last Friday. Any help
would be greatly appreciated.

Thanks,
Jeffery M. Curl
Systems Administrator
 
I just found my mistake. I needed a "_" between Clock Number. Thanks,

Jeffery M. Curl
Systems Administrator
 
Back
Top