Command Button on Split Form Datasheet?

Question

This is a Split Form. Currently I'm opening an editing form from the on click of my AutoNumber ID field in the datasheet. I set the 'Display As Hyperlink'  property to Screen Only. I've seen this in Access examples that I have downloaded. I wouild rather have a command button to perform this operation, which means I'll need a button for each row. I can do this with contiunouos forms but not sure how to do it or if I can dot with Split Forms.

Any idea how I might accomplish this?

James

Answer 1

Forms in datasheet view - and that includes the datasheet part of a split form - can only display text boxes, combo boxes and check boxes. There is no way to display a command button.

You'd have to create your own split form by combining a continuous form and a standard form; this requires writing code to keep them synchronized. Probably more work than it's worth.

Answer 2

Ok. Thanks