eed
12-01-2005, 01:52 PM
Hi, all,
Is there a command I could attach to a button to toggle a subform between Continuous Form view and Datasheet view?
I had briefly thought I could just set the CurrentView property, but this is read-only; duh, me. Closing and reopening the entire main form so that I can change the subform in design view is not really an option in this case.
If I can't just toggle the view while the subform is open, I guess I can have two subforms based on the same recordset, one in each view, and the button could actually toggle the source of the subform...? http://vbaexpress.com/forum/images/smilies/think.gif
Any ideas welcomed with appreciation,
eed
Is there a command I could attach to a button to toggle a subform between Continuous Form view and Datasheet view?
I had briefly thought I could just set the CurrentView property, but this is read-only; duh, me. Closing and reopening the entire main form so that I can change the subform in design view is not really an option in this case.
If I can't just toggle the view while the subform is open, I guess I can have two subforms based on the same recordset, one in each view, and the button could actually toggle the source of the subform...? http://vbaexpress.com/forum/images/smilies/think.gif
Any ideas welcomed with appreciation,
eed