Open record from button/link in datasheet

[treva26]

I have a summary form with a datasheet subform.

What I want is one of the columns in the datasheet to have a button or a link to open that record in the full detail form (my "Smart Sheet Form").

I'd also like to close the summary form when the detail form opens if possible.

 

[KenHigg]

Instead of datasheet, have the subform display in contiuous forms view and you put your button there.



ken

 

[treva26]

Yea I thought that might be the way. Guess I could do that.

No way of doing it in a datasheet then?

 

[KenHigg]

Not that I know of... There are other major upsides to the continuous forms method like control of formatting, event trapping, etc...

 

[treva26]

Yea good point.
I am now using a continuous form.
I have my button and can now also hide a couple of fields I don't need to see.
Thanks

 

[CEH]

I did not open your DB, but I use the exact method you describe. I have parameters that return a data sheet. On one of the fields you can doubleclick (I indicate this ability by making the field text blue) to open a detail of that record. So, just for your information, it can be done.