Solved Expression builder Form Object Frame

[Sarah.M]

Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity).
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
How can I tell that this is a Report or a Form through the expression builder?, Because I want to use If function iif this Report do this Else Do that etc..
This is [SelectionType] just example, becuse I did not find it in expression builder Form Object Frame

plz help me to find a way to solve it , or if you have alternative way to determine this a form or a report please let us know

 

[arnelgp]

Object Frame value is Numeric.
the first Item is 1, the second is 2 and so on.
supposed that what you put on the first item is a form:

you can use Choose() function to test your [Selection Type].
Choose will test if it is 1, 2, 3, etc:

supposed the first option is a form, then the second is a report:

Choose([Selection Type], "this is a form", "this is a report")

 

[Sarah.M]

Object Frame value is Numeric.
the first Item is 1, the second is 2 and so on.
supposed that what you put on the first item is a form:

you can use Choose() function to test your [Selection Type].
Choose will test if it is 1, 2, 3, etc:

supposed the first option is a form, then the second is a report:

Choose([Selection Type], "this is a form", "this is a report")

I tried, I got error plz help
sample attached

 

[arnelgp]

i can't find where is [SelectionType] on your form, table, or query?

 

[Sarah.M]

i can't find where is [SelectionType] on your form, table, or query?

Thanks for replying
[SelectionType] I could not find it in Expression Builder, that is why I ask to find out the way to get it

 

[Pat Hartman]

I guess I don't understand why you don't know what type of object you opened. Can you explain the business problem please.

 

[Sarah.M]

I guess I don't understand why you don't know what type of object you opened. Can you explain the business problem please.

Thanks for replying
If I can distinguish between a form and a report it will help me a lot in customizing some macro commands
plz see the attached picture
Sample attached
plz help

 

[Pat Hartman]

I don't use macros. Can you just leave the type empty and have it close whatever object is active? or specify "active object"

 

[Sarah.M]

I don't use macros. Can you just leave the type empty and have it close whatever object is active? or specify "active object"

it works thanks!

 

[Pat Hartman]

Whoooey. I solved a macro problem Happy dance time