Open form on load

[Wlbyfred]

Hello


Can anyone give me some help on having a form open on load.

I have opened form in design mode
on event tab clicked on ... on the onload line
selected gotorecord dbl clicked
entered form
form name
new

Then tried to save it and no save box came up,tried to run it, asked if I wanted to save said yes
the change does not stay when I try it afterclosing database and reopening. I have done this before but has been some time....what am I doing wrong

Thanks

[June7]

Click this ellipses (...). Choose: Macro Builder, Expression Builder, or Code Builder.

I use only VBA so I would choose Code Builder.

If you want a macro (which is what your posted example looks like) then choose Macro Builder.

[Wlbyfred]

Click this ellipses (...). Choose: Macro Builder, Expression Builder, or Code Builder.

I use only VBA so I would choose Code Builder.

If you want a macro (which is what your posted example looks like) then choose Macro Builder.

How to I get it to save, I can go through the dialog box but when I save nothing happens and it does not apply. Am I missing a step
Thanks

[Wlbyfred]

Ok
Now this thing is driving me crazy...I can't move to new record from form. Is it possible to upload a copy of file and have someone look at it. I must be doing something wrong I did this last year and can not replicate what I did.
Thanks

[June7]

Follow instructions at bottom of my post.

[Wlbyfred]

ThanksMPL_Workorder11.zip

[June7]

The form DataEntry property is set Yes. This means the form cannot display existing records. Why do you need code?

I have no problem entering new record, however, the code prevents display of records just created in the session.

Why are Manager and Location fields set up as multi-value?

[Wlbyfred]

Ok
What I want to be able to do is when a manager opens this database the first thing they see is the form open and ready to use...I am fustrated because I did this last year on a db and had no problem...just cant seem to make it work...I know it has to be something simple. I am not sure I understand multi-values.
Thanks for all your help...

[June7]

Regarding multi-value field review http://office.microsoft.com/en-us/ac...001233722.aspx

I don't think multi-value is appropriate for your data. This is a property set on the field in table. Change it to No. I NEVER use multi-value field.

Where is the db that works? Review it and apply to this db. You might have simply set project options for a default form. From the ribbon: File > Options > Current Database > select options as desired.

[Wlbyfred]

It was not as functional as I would have liked and made changes with out saving copies...still have a lot to learn about db management and design, although I have been watching training videos on safari online. Ok I'll ck the options. With this db I have made copies all along the way...even though its a simple and small one. The one I sent you is the one that was furthest along and I just wanted to have the form open when the db was open.
THanks

[Wlbyfred]

OK
I have to thank you...that was it! Now I can continue with what I was doing.
Thanks for your time and patience.