Click on row (record) in subform to open that record?

[Orv]

I have a search form which contains a non-linked subform. When I fill the
criteria of my search and click the search button it returns the results in
the subform, datasheet view.

I then want to select/click on the row (record) on the datasheet and have
that record pop-up.

Any ideas?

TIA,
-Orv

[Rick Brandt]

"Orv" <pcbidderathotmail.comwrote in message
news:D8******************************@comcast.com. ..

>I have a search form which contains a non-linked subform. When I fill the
criteria of my search and click the search button it returns the results in the
subform, datasheet view.

I then want to select/click on the row (record) on the datasheet and have
that record pop-up.

Any ideas?

Not so easy with a datasheet view. If you used a continuous view set up to look
like a datasheet then it is easy. You can create a command button that covers
the entire row of controls and set it to transparent. The command button wizard
will create a button for you that does the rest of what you are asking for.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Orv]

"Rick Brandt" <ri*********@hotmail.comwrote in message
news:0Z****************@newssvr19.news.prodigy.net ...

"Orv" <pcbidderathotmail.comwrote in message
news:D8******************************@comcast.com. ..

>>I have a search form which contains a non-linked subform. When I fill the
criteria of my search and click the search button it returns the results
in the subform, datasheet view.

I then want to select/click on the row (record) on the datasheet and
have that record pop-up.

Any ideas?

Not so easy with a datasheet view. If you used a continuous view set up
to look like a datasheet then it is easy. You can create a command button
that covers the entire row of controls and set it to transparent. The
command button wizard will create a button for you that does the rest of
what you are asking for.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Thanks...this works great.

How do I show the field/column headers of the subform? I have them in the
header however they do not show up.

[Rick Brandt]

"Orv" <pcbidderathotmail.comwrote in message
news:6a******************************@comcast.com. ..

How do I show the field/column headers of the subform? I have them in the
header however they do not show up.

Did you use the PageHeader or the FormHeader? The former is only for printing.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Orv]

With a little trial and error I got it. Thanks for all the help.

"Rick Brandt" <ri*********@hotmail.comwrote in message
news:j%******************@newssvr22.news.prodigy.n et...

"Orv" <pcbidderathotmail.comwrote in message
news:6a******************************@comcast.com. ..

>How do I show the field/column headers of the subform? I have them in the
header however they do not show up.

Did you use the PageHeader or the FormHeader? The former is only for
printing.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com