From: Bill on
That did the trick! I had to put it in an event procedure.

Thanks

"Dirk Goldgar" wrote:

> "Bill" <Bill(a)discussions.microsoft.com> wrote in message
> news:CF3449A5-D2F6-41E9-ABA0-93BE61A0F0EB(a)microsoft.com...
> >
> >
> > Here is what I typed DoCmd.OpenForm "Tenants Move In". . . .acFormAdd
>
>
> I see you have periods instead of commas. That would certainly be an error.
>
> Did you type that directly into the button's On Click event property (that
> would be an error), or did you create an event procedure and put this line
> of code inside that event procedure (that would be the right way to do it)?
>
> --
> Dirk Goldgar, MS Access MVP
> Access tips: www.datagnostics.com/tips.html
>
> (please reply to the newsgroup)
>