Subform to change from Datasheet View to Continuous Form View

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a form with subform and multible users. When they update data they
want to see the same information others in Datasheet View and others in
Continous Form View.

I tried to see some code examples, but could not find. Is it possible? Is it
wise? Or should I just make two different forms and subforms? The last one
does not seen very wise due to a fact that there are multiple possibilities
to filter data.

Any help would be great.
MakeLei
 
Try

Me.TableName4.SetFocus
' To change to DataSheet view
Application.RunCommand acCmdSubformDatasheet

' To change to Form view
Application.RunCommand acCmdSubformFormView
 
Thanks Ofer
Works like a charm!

This made my day ;o)
MakeLei

Ofer Cohen said:
Sorry, the TableName4 stand for SubForm control name

Me.[SubForm control name].SetFocus


--
Good Luck
BS"D


Ofer Cohen said:
Try

Me.TableName4.SetFocus
' To change to DataSheet view
Application.RunCommand acCmdSubformDatasheet

' To change to Form view
Application.RunCommand acCmdSubformFormView
Click to expand...
Click to expand...
 
Back
Top