Checking where from the form was called

[giedrius]

Hello,

How could I check where from my form was called? I need to trap when the form is called from the switchboard or directly by double-clicking on it in the Forms window.

thanks for any tips,
giedrius

 

[FoFa]

Typically I put an invisible field on the form, and set it to a value depending on where it was called from.

 

[Mile-O]

Send the name of the calling form to the new form in the OpenArgs


i.e.

DoCmd.OpenForm "MyForm", , , , , , Me.Name

 

[giedrius]

What if I already am passing an argument? IS there a possibility to pass 2 or more arguments?

giedrius

 

[Mile-O]

Separate them with a delimiter and then split them on the other side.

Here's a bit of code I wrote to extract the different parts of a delimited string.

 

[giedrius]

Thanks Mile. I somehow lost track of this my question.

giedrius