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

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 (AT) hotmail (DOT) com> wrote


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

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 (AT) hotmail (DOT) com> wrote