Re: how do i use VBA to change form view
- From: "Ken Snell \(MVP\)" <kthsneisllis9@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 4 Jul 2006 18:00:35 -0400
This line of code (where SubformName is the name of the control that holds
the subform object) should do that, if the subform object allows you to view
the single form view:
Me.SubformName.Form.DefaultView = 0
Note that these are the numbers (from Help file) for the different views:
Setting Visual Basic
Single Form 0
Continuous Forms 1
Data*** 2
PivotTable 3
PivotChart 4
--
Ken Snell
<MS ACCESS MVP>
"bneq" <bneq@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E74FB70B-BB34-4C0A-8E62-B2BB717CE695@xxxxxxxxxxxxxxxx
Greetings to all.
Can anyone tell me please how to use VBA to change a subform's view from
"data***" to "single-form"?
Thanks for any tips.
Ben.
.
- Prev by Date: Re: Scroll through records and get match
- Next by Date: Re: how do i use VBA to change form view
- Previous by thread: Re: Where are the blank characters?
- Next by thread: Re: how do i use VBA to change form view
- Index(es):
