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

"Orv" <pcbidderathotmail.comwrote in message
news:D8adnbS1JJDkhE3bnZ2dnUVZ_j2dnZ2d@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

"Rick Brandt" <rickbrandt2@hotmail.comwrote in message
news:0ZUzi.5311$i75.318@newssvr19.news.prodigy.net ...

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

>
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.

"Orv" <pcbidderathotmail.comwrote in message
news:6aqdnbCKNJEvsE3bnZ2dnUVZ_g2dnZ2d@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

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



"Rick Brandt" <rickbrandt2@hotmail.comwrote in message
news:j%5Ai.13315$4w7.7247@newssvr22.news.prodigy.n et...

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

>
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
>