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 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.com> wrote in message 
news:0ZUzi.5311$i75.318@newssvr19.news.prodigy.net...
> "Orv" <pcbidderathotmail.com> wrote 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
  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.com> wrote 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.com> wrote in message 
news:j%5Ai.13315$4w7.7247@newssvr22.news.prodigy.net...
> "Orv" <pcbidderathotmail.com> wrote 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
>