Can I: click on datasheet row to move to record detail

[Jeanne]

Trying to construct a form where the user can click on a datasheet row, the
application then takes the user to fill detail about the individual record.
How can I do that?

 

[Keith Wilby]

Trying to construct a form where the user can click on a datasheet row,
the
application then takes the user to fill detail about the individual
record.
How can I do that?

Put some code in the form's Current event to open up your data entry form
(untested air code follows):

DoCmd.OpenForm "frmDataEntry",,,"[ID]=" & Me.txtID

This assumes you have a text box called "txtID" on your main form bound to
a numberic. Also I have guessed the number of commas required for the
"where" argument but intellisense will guide you.

All that said I'm not at all sure that you *need* such functionality but
then you haven't given much to go on.

Keith.
www.keithwilby.co.uk

 

[Jeanne]

More info: I have a form with many records (datasheet). I need some way to
click on one of the many records, which will redirect the user to another
form. I've seen forms built with one of the columns data having an
underline, where one can click to be redirected somewhere else. How can I do
it?
--
Jeanne

Trying to construct a form where the user can click on a datasheet row,
the
application then takes the user to fill detail about the individual
record.
How can I do that?

Put some code in the form's Current event to open up your data entry form
(untested air code follows):

DoCmd.OpenForm "frmDataEntry",,,"[ID]=" & Me.txtID

This assumes you have a text box called "txtID" on your main form bound to
a numberic. Also I have guessed the number of commas required for the
"where" argument but intellisense will guide you.

All that said I'm not at all sure that you *need* such functionality but
then you haven't given much to go on.

Keith.
www.keithwilby.co.uk