Access 2003: Buttons for switching between form and datasheet view

[Guest]

I'd like to be able to allow users to push a button and switch into datasheet
view to select records which would then be edited back in form view. (Just
like a FoxPro browse screen). Is there an elegant way to do this? Right
now I've got a button
on the form which runs DoCmd.OpenForm "RMA", acFormDS and goes to the
DataSheet, but I don't know how to get back to the form.

Since the target for this is the Access 2003 runtime, the normal toolbar
menu commands aren't available to return to the form (Alt-V, F).
Thanks.

 

[Guest]

Create a custom toolbar, and then add the datasheet view and form view
buttons to the toolbar (by customizing the menus), your form should have that
toolbar setup under tab Other in the properties window in your form, they
will be available in runtime version of the application

 

[Albert D.Kallal]

I actually prefer placing a button on the continuous form. When the user
hits enter, or clicks on the button, then I simply open up another nice
form. This way, you can build a very nice browse screen, and then also build
a very nice "main edit" form that allows viewing, and editing of the SINGLE
record. My users tend to like this approach also, and you don't mess up a
form by having it trying to be a datasheet vs a form.

The code behind the buttion to open another form to the ONE rocord is

docmd.OpenForm "frmCustomer",,,"id = " & me!id


Here is some screen shots of what I mean:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

And, here is antoher example of a browse, and search screen:

http://www.members.shaw.ca/AlbertKallal/Search/index.html