buttons in datasheet

[Guest]

Could anyone help to show me how to add a button as one of the column in a
datasheet subform? The button would mostly open the current record in the
subform in a new single form.

many thanks.

or better yet, how to turn the datasheet row into a hyperlink so the user
can click and navigate to that record opened in a new single form?

 

[Arvin Meyer [MVP]]

You can't put a button in a datasheet. You have several other choices:

1. Use the double-click event of the form, which will fire when you
double-click the record selector on the datasheet.

2. Use a continuous form made to look like a datasheet.

Be aware, that if you start to edit the subform, you will lock the record
and be unable to edit it in single form view. In that case you can make the
subform read-only, so that records can only be added or edited through the
single form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks, that would do the job.

You can't put a button in a datasheet. You have several other choices:

1. Use the double-click event of the form, which will fire when you
double-click the record selector on the datasheet.

2. Use a continuous form made to look like a datasheet.

Be aware, that if you start to edit the subform, you will lock the record
and be unable to edit it in single form view. In that case you can make the
subform read-only, so that records can only be added or edited through the
single form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access