Add command button to a subform

[Tom]

I have created a form that contains a subform. I am
trying to add a command button to the subform to open a
different form based on the currently selected record in
the subform. I have tried adding the button to the
subform Detail section, the subform's Form Header, and to
the Footer section, but it never appears when I view the
form in data view. I have checked the Properties for the
button and it is is set as Visible and to Always display,
but it is never visible when I am in data view. It is
always visible in Design view, but never in Data view.

Does anyone know if you can add command buttons to
subforms, and if so, how do you make them visible and
available when you view the form?

 

[Ken Snell]

When you say "data" view, do you mean "datasheet" view? If so, you cannot
show controls in this view. What you'll see will be either textboxes or
combo boxes (depending upon how you set up your table). You need to use the
"continuous forms" view to see buttons, etc.

 

[John Viescas]

Tom-

If by "data view" you mean you've designed the subform as a Datasheet, then
you'll never see the button. You must set the subform to display in Single
Form or Continuous Form view. You can design the form to look similar to a
datasheet. Design the detail area so that it's only a bit taller than one
row high, put the labels in the header, and line up your controls in a
single row under the labels.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)