Forms in two differant views

  • Thread starter Thread starter Rose
  • Start date Start date
R

Rose

Is there a way to use the same sub form showing two differant views within
the same Main Form. For example: Can I show on one tab a datasheet view and
on the other a regular form view.
 
Hi Rose,
Create a button on your form and under the "OnClick" event put
'Me.DefaultView = Datasheet
Alternatively you could use a checkbox

If me.checkbox1 = 0 then
Me.DefaultView = 2 ' Datasheet
Else
Me.DefaultView = 0 'Single Form
End if
me.repaint

This should flick the form between datasheet and form views.

HTH,
Nick.
 
Thank You!
--
Rose


Biz Enhancer said:
Hi Rose,
Create a button on your form and under the "OnClick" event put
'Me.DefaultView = Datasheet
Alternatively you could use a checkbox

If me.checkbox1 = 0 then
Me.DefaultView = 2 ' Datasheet
Else
Me.DefaultView = 0 'Single Form
End if
me.repaint

This should flick the form between datasheet and form views.

HTH,
Nick.
Click to expand...
 
Back
Top