Opening a Form in Datasheet Mode.

[Robeen]

Hi,

Access 2010.

I am using this:

DoCmd.OpenForm "PreviousEntries", 3, , , , , "Start"

to open a Form in Datasheet mode.

However, in design view for "PreviousEntries" - I have an Exit button - and that button does not show up when the Form opens up as a Datasheet at run time.
I want to show the data in Datasheet mode - but I also want an Exit button on the form so I can return to the 'calling' form ["Start"].

In design view - the form that is being opened in DS view at run time does not appear as a 'Datasheet' but as a 'regular' Form - with controls running down the form vertically.

I'd appreciate any help.

Thanks!

Robeen

[rpeare]

I'm guessing your 'exit' button is in your form header, which is the limtiation of opening something in datasheet view.

Why not create a form that looks just like a datasheet then your form header (and therefore exit button) will be visible.

[June7]

Use Continuous view and arrange controls horizontally to appear as datasheet. The appearance will be very close.

Or allow users to use the X close button and put code in that event to return focus to Start.

[Bob Fitz]

I don't think you can show the button when the form is in datasheet view. Not sure if you could show the button if you redesign the form as a continuous form. I would create a new form and put your existing form on that new form as a subform. You could then have the button on the new form.

Edit:
June7, you type so quick!

[June7]

And rpeare even faster!

The button will show with Continuous view.

[Bob Fitz]

And rpeare even faster!

Clearly. I didn't even see that post

The button will show with Continuous view.

I thought that was the case but wasn't sure without testing and didn't want to take the chance of miss-informing the OP.

[Robeen]

Thanks, everyone!
I just added my Form to another Form as a Sub-Form.
Appreciate all your suggestions.
P.S. I could not get the button to show when I earlier tried it as a Continuous Form.

[June7]

The continuous form is working with button now?

A Single form and Continous aren't really very different, just the Continous allows 'continuous' scrolling of records, whereas Single navigates one record at a time. All the same form sections are available in both. A continuous form will not be allowed if there is a subform.