Solved: coding for DesignView & FormView ?

[beginner]

hi all....

appreciated very much if anyone could adv. the VBA coding to activate the Form's DesignView and FormView ?
( as i need to simulate the action to toggle the form to Form's DesignView & then back to FormView immediately )

It seems "Forms![xxxx].Requery" not good enough to achieve what i need.


Thanks a lot. :hi:

[Norie]

Do you mean you want to open a form in design view?

[beginner]

hi Norie,

i need adv. on the VBA code inside the below button to do the following.:-
- when a Form is already open at normal FormView, then
- click the button to go to DesignView and then back again to FormView again.

or any other alternative can achieve same result still ok, tks for any adv.

beginner

[beginner]

hi Norie,

i am a bit stupid here and i should do it to close the Form and reOpen the Form (as it default to the FormView) again that can achieve what i need. sorry for confusing. Tks.