Button in Subform

[MikeB]

I have a form with a subform. The subform displays in Datasheet mode.
I would like to have a button on each row of the subform so that it
wil lopen a related form in dialog mode. I can't seem to display the
button on the subform if the subform is in datasheet mode.

Is there another way to get what I want?

Thanks again.

 

[CrazyAccessProgrammer]

Form controls won't display in a form when the form is running in datasheet
view.

One workaround would be to put the event code that you have behind your
button into the double-click event behind one of the fields that appear in
your subform. You could have a controltiptext display to instructt the user
to 'double click here to enter myformname'

The only other alternative I can think of is to have your subform in
'Continous Forms' mode instead of 'Datasheet' mode. With some careful form
customizing, you can make continous forms look very close to datasheet view
with the added perk of form controls such as buttons being available.

 

[MikeB]

I have a form with a subform. The subform displays in Datasheet mode.
I would like to have a button on each row of the subform so that it
wil lopen a related form in dialog mode. I can't seem to display the
button on the subform if the subform is in datasheet mode.

Is there another way to get what I want?

Thanks again.

Hey kind folks. I gave up on this and simply created the form as a
continuous form and it works more or less. I guess it wasn't possible
to display buttons in Datasheet mode.

Thanks anyway.