Simple Help 1

[thelke]

What would the OnLoad() VBA code be for a form, so it opens in ADD mode instead of EDIT mode. Did this make sense?

 

[Dreamwalker]

hey hey

Try this when you open the form in vba

DoCmd.OpenForm "formname", , , , acFormAdd

Cheers
Vince

 

[thelke]

That did not work

 

[thelke]

Got it, my mistake. Thanks

 

[thelke]

ok, still not working. I have a switchboard with a treeview. now, when I clikc on the link for this form, it opens it in the parent area, AND opens an instance of itself OUTSIDE of the form.

 

[jebry]

Hi!

If you need to use the Load event then use:

Me.AllowEdits = False
Me.AllowDeletes = False
Me.AllowAdditions = True

Of course, you will need to make it conditional somehow or the form will always open in add mode.

BTW, Vince's code works well, but you can not use it in the Load event, it must be used when opening the form in code.

hth
Jeff Bridgham
bridgham@purdue.edu