Continuous Form unclickable once filtered

[KyleMac]

New here but I've been playing with MS Access for a few years. I recently ran into an issue I cannot seem to solve or find an answer to.



I have created a form that filters information from a table via combo boxes and check boxes. The data all filters beautifully but I cannot click on most of the data once it is filtered. When no filter is in place I can click on anything. I need to be able to click on the data because they are text boxes and when clicked on I need it to open a form based off which is clicked. The first .jpg is the design view of the form. Second image is what things look like while mostly working.

Edit: I neglected to mention I can click on the first item filtered, but all others just "refresh" the form when I try to click on them. If nothing is filtered I can click on anything.

[June7]

All looks good. Need to see code and form properties.

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

[KyleMac]

All looks good. Need to see code and form properties.

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

As suggested:
Spell Compendium v4.zip

edit: Fixed uploaded version (the other one was my test file where I was playing with settings to try and get it to work)

[June7]

I would use just AfterUpdate events of input controls. I have never used Change event. It fires after each typed character in box.

I don't think should use Requery in each event - there are no parameters to requery for since the RecordSource is not a dynamic parameterized query. Need to call filter code. Put the filter code in a Sub that can be called by each event. Although not sure why it would be needed in Current event.

Private Sub School_Change()
    Call SetFilter
End Sub

Private Sub Form_Current()
    Call SetFilter
End Sub

Private Sub SetFilter()
...
End Sub

Me.Form is not necessary but doesn't hurt - Me. is adequate, as in:

Me.Requery
Me.Repaint (should this have been Requery?)
Me.InsideHeight

I would open the SpellDescription form with:

Private Sub Names_DblClick(Cancel As Integer)
    DoCmd.OpenForm "SpellDescription", , , "Spellname='" & Me.Spellname & "'", acFormEdit
End Sub

And eliminate the filter code in SpellDescription open event:

Private Sub Form_Open(Cancel As Integer)
    Me.SpellNames = Me!Spellname
End Sub

Why not have combobox on SpellDescription for selecting Spellname?

However, even after these changes, the issue persists. Records are not selectable after filter is applied. I was right about the Current event. Got rid of it and now it all works.

[KyleMac]

You got it before I edited the .zip file. I was playing around with different ideas to try and fix it, that's why one was .repaint. Thanks for the optimization suggestions as well! Working thanks to your suggestions, learned some things too, thanks!

There are soooo many spells (that's why SpellDescription doesn't have a combobox). I actually hid the textbox and made the caption change to whatever spell had been clicked on to clean up the look of it.

[June7]

You might find these of interest
http://allenbrowne.com/ser-32.html
http://allenbrowne.com/AppFindAsUType.html