Toggle Between Table and Form View? 
Author Message
 Toggle Between Table and Form View?

I'd like to create a keyboard shortcut or toolbar button that will
toggle between displaying a selected record in table view and showing
that same record in a form I've created. This is a built-in feature of
Paradox (function key F6 toggles the views) but, for the life of me, I
can't find a similar capability in Access. I suspect it can be done with
a macro or a little VBA code. Can anybody tell me how to do it?

Thanks.

----- Rick Alber



Mon, 02 Apr 2001 03:00:00 GMT  
 Toggle Between Table and Form View?
You don't want your user in the table.

To give them a view similar to a table use a datasheet view.  You can't
toggle like you do in Pdox, but you can give them a toolbar icon and a menu
choice to do the job.

--
Steve Clark (Aspiring MS MVP)
FMS, Inc.
Work: http://www.fmsinc.com
Play: http://members.xoom.com/SteveClark/SC_Home.htm



Tue, 03 Apr 2001 03:00:00 GMT  
 Toggle Between Table and Form View?
I do this by putting code in a DoubleClick event for a field in the form:

Private Sub FieldName_DblClick(Cancel As Integer)
If Me.CurrentView = 1 Then 'form view
    DoCmd.RunCommand acCmdDatasheetView
ElseIf Me.CurrentView = 2 Then 'datasheet view
    DoCmd.RunCommand acCmdFormView
End If
End Sub

If it's a subform can just use this:

Private Sub FieldName_DblClick(Cancel As Integer)
    DoCmd.RunCommand acCmdSubformDatasheet
End Sub

Quote:

>I'd like to create a keyboard shortcut or toolbar button that will
>toggle between displaying a selected record in table view and showing
>that same record in a form I've created.



Tue, 03 Apr 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Toggle Between Table and Form View of Data?

2. Toggling between Form view & Datasheet view

3. Toggle Subform from Form-view to Datasheet-view Programatically

4. Toggle Subform between Form-view and Datasheet-view Programmatically

5. Toggle Between Form and Datasheet Views

6. Toggle between datasheet and form view in subform

7. Programmatic toggle form between FormView and Datasheet view

8. Probably a no brainer (form view toggle??)

9. how to create a toggle to view form

10. Toggle Between Form and Table?


 
Powered by phpBB® Forum Software © phpBB Group