Returning Records Based on Indiv Cell Clicks

[peryan77]

Here is my Subform in datasheet view (Based off a sub-query)

Buildin Internal_FA Internal_PC
MAASH 20 25
MABRO 143 142
MADAR 24 24
MADED 257 166
MAHIG 1
MALEO 21 20
MALOG 47 40
MAMAV 1 7
MANKT 4 4

I want to be able to click in any of the cells example 25 for MAASH) and pull up just that list of PCs. So I need a way to return the Column name and Building name where I click in the datasheet subform.

Thanks

 

[PHV]

Isn't a continuous form an option ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[peryan77]

I suppose, but they are soo ugly.