Subform to change from Datasheet View to Continuous Form View

M

MakeLei

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
 
O

Ofer Cohen

Try

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

' To change to Form view
Application.RunCommand acCmdSubformFormView
 
O

Ofer Cohen

Sorry, the TableName4 stand for SubForm control name

Me.[SubForm control name].SetFocus
 
M

MakeLei

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...
 
Top