Solved Access subform not able to select record (1 Viewer)

[forshoeb]

Hi, I have a subform which displays a query in datasheet mode. I was able to select a record and display data related to it using another subform until 2 days back. But since yesterday the subform is behaving weird. When I try to select a record or move mouse on the subform, it is turning grey. I am not able to select any record. I tried running query directly which is showing on subform but the query seems to run fine. The greying out area looks like query in design mode.

Does anyone know what cause this problem and solution to it?

 

[June7]

Did anything change?

If you want to provide db for analysis, follow instructions at bottom of my post.

 

[Josef P.]

looks like https://www.access-programmers.co.u...h-suforms-using-query-as-sourceobject.326908/