With, End With

[LittleMan22]

Is it possible to have two sets of WITH commands?

For example I want (and currently have) my first with set at Forms!frmClients!frmDataEntry but it would be great if I could put in another with to say Forms!subformPolicies.

Is this possible?

Ryan.

 

[Lozere]

Probably no

When you embed Whith clause, the inner one only is meaningful

If these shortcut are very important for you, you can declare Control, Form, ... object

>>Dim My1 as Control, My2 as Form

and further set them

>>Set My1=Forms!frmClients!frmDataEntry
>>Set My2=Forms!subformPolicies

And then use these objects:
>>My1.property1=.....
>>My2.ControlXX=....

 

[cdidion]

You could create an object reference to the forms and use those reference as shortcuts in your code:

Dim oForm as Form

Set oForm = Forms!subformPolicies

Then use oForm wherever you would have used Forms!subformPolicies:

oForm!txtName.value = "Whatever"

Then at the end of your code release the object reference by setting it to Nothing:

Set oForm = Nothing

Hope that helped. -Chris Didion
Matrix Automation, MCP