Form parameters

[DebSabre]

I have one form I would like to open from two different places. In one case I would like to open the form with some fields disabled, in another place I would like the form opened with all fields enabled. I hate to build a copy of the same form for this. Can I pass a parameter so that it may change its behaviour?

 

[Mile-O]

You can use the Form's OpenArgs when opening a form in code.

i.e.

DoCmd.OpenForm "frmYourFormName", , , , , , "These Are The OpenArgs"

On the Form you wish to use, you can then review the value of the OpenArgs and disable controls accordingly.

 

[DebSabre]

Thanks

Thanks, that's what I needed.