Command button not showing on sub form Access 2007

[ijyoung]

Am trying to customise automation in Access 2007/Outlook.
Using MS template which works ok. However, I have the form set up as a subform an embedded in the main form Although the form works fine in isolation, it does not display its command button when viewed with main form.
I am fairly new to this stuff so clearly have done something stupid.
In addition, I want to be able to use the check box so that I don't have to add every entry to Outlook and also have Outlook updated on "enter/tab" at end of entry.

Is this possible

Cheers

Ian

[missinglinq]

Sorry no one responded to this sooner. We're all volunteers, of course, and and on heavy posting days, some questions simply go down the list until they're off the first page. Once or twice a week, depending on life, I cruise the "unanswered threads" listing, and so found this one!

The reason that the command button is missing when the form is displayed as a subform is that it's in Datasheet View, and this view doesn't display unbound objects, such as command buttons or unbound checkboxes, comboboxes textboxes, etc.

You can remedy this by changing the Default View property of the form to Continuous View, then tweak the formatting so that it looks like a Datasheet View.

I want to be able to use the check box so that I don't have to add every entry to Outlook and also have Outlook updated on "enter/tab" at end of entry.

I'm sorry, but this statement makes no sense at all, by itself. You always have to remember, when posting on a forum like this, that you can see your database, but we can't! You'll have to explain this problem more clearly in order for someone to help you.

Welcome to Bytes!

Linq ;0)>

[robin a]

Another possibility is, if you already have your subform in continuous view and the command button still doesnt show, then you may have the command button placed in the PAGE footer instead for the FORM footer. If this is the case, right click in the form and choose "view form footer" then place the command button in the FORM footer. hope this helps!