A2003: show button on subform

[bulrush]

WinXP with A2003

I would like to make a form with a subform. On the subform I show only a few fields. The detail record on the subform actually has many more fields (about 35). So I want to show an Edit button on the subform. When the user clicks the Edit button, I am taken to another version of the subform which shows all 35 fields which the user can edit.

But, on my embedded subform, the text boxes show (that is good) but the button is hidden. I have never used buttons on a subform, only text boxes.

How do I show a button on my embedded subform so I can edit this detail record on another form?

Thanks.

 

[boblarson]

You would have to use a Continuous form (you can format it to look like a datasheet) or Single form view for the subform in order for the button to show up. Datasheet view won't let you display a button.

 

[bulrush]

Ah, thanks. I was using Datasheet view.

 

[missinglinq]

An alternative, if you want to stick with the Datasheet View for the Subform, would be to use the DoubleClick event of one or more of your textboxes to open your second form. Just use the same code as your Command Button.

Linq ;0)>

 

[boblarson]

An alternative, if you want to stick with the Datasheet View for the Subform, would be to use the DoubleClick event of one or more of your textboxes to open your second form. Just use the same code as your Command Button.

Yep, good suggestion. I've done that in the past as well.