Hi Richard
Me again! Lesson 4 keeps stopping at 14.31.

OK. I'll recompile and re-upload it. That happens sometimes with these big video files. You can skip ahead in the video if you catch it before it locks up, but you'll miss a little. Recompiling it usually fixes it. Give me about an hour.

Groups
Can you add the same Entity to a group multiple times?

Probably. I didn't put anything in there to prevent it. I'll add this to the bug fix list.

Hi Richard
After the SQL sort at the very end of lesson, I now get "Enter Parameter Value" EntityListName.
I have gone over the code again and again and can't find an error. i have copied and pasted below. Was working great until then. HELP.

Public Sub LoadGroupMembers()
    
    GroupSubF.Form.RecordSource = "SELECT * FROM EntityXGroupQ WHERE GroupID=" & GroupList & " ORDER BY EntityListName"
    GroupSubF.Form.AllowAdditions = True

End Sub

Does EntityListName exist in your EntityXGroupQ?
Have you tried making a new Query in the Editor, hard coding the GroupID and testing it that way?
This Query did change in versions, did you pick an earlier version and not add the extra columns with the new name calculations?

99% of the time unexpected "Enter Parameter Value" prompts are caused by a misspelling somewhere.

I know... you have said that many times. I just can't find it!
I will try again now that i have had a sleep, hopefully fresh eyes will find it.

I don't know how many times I spent HOURS trying to hunt down a bug... late at night... tired as can be... then I sleep on it and find the problem FIRST thing in the morning... like DUH!

Would you believe a restart fixed the problem! I forgot about the obvious!

I absolutely 100% do believe that. I've seen that a million times. Hence, the Troubleshooter.