I took a look - I don't experience most of those messages but maybe that has something to do with having to remove a reference that I don't have in Program Files(x86).
Anyway, you need to step through your code and really think about what you want each step to do, what you're giving it/telling it, and watch what it is exactly doing. You also need to realize that when a procedure ends, whatever you think you created/set in it is gone IF those variables are local to that procedure. F'rinstance, you create a recordset (see post 4) then End Sub and the recordset variable scope is to that procedure only, so totally useless code.
Then you use form current to create a recordset. If that rs only ever returns at most 1 record, then just bind the form to the query since you are using nav buttons to move from record to record. Right now, each time you move to another record you're running the event again to do what - get the next record? I don't know yet because I'm in the middle of stepping.
OK, next you attempt to pass a form to another sub and set a variable to its recordset count - you cannot pass a form and deal with its recordset. You can only deal with its recordsetclone but you can't get at it from there (and you're trying to do that at least twice). Even if you could the count would be 1 anyway, because you never did Move Last before that. So leaving that procedure (since the rest of it doesn't run anyway, at least for me) you have error handling blocks that your code goes into automatically because you don't exit sub before that. Thus they run anyway.
Most of your issues seem to stem from not binding your form to a table or query and let Access do the heavy lifting. Instead, you take the approach of building a (sort of) Rube Goldberg machine. That might be OK if you had developed robust vba skills, but that is not really the case here. One day that might be a different story, but you have to learn to crawl before you can walk. I hope you don't take any of that as harsh criticism, no more than I would if you had seen my investment management skills at work. You would tell me to contract that out, which is maybe something you'd want to consider since as long as you're dabbling in this, you are losing time that you might better devote to your investment dealings?
Last,
I DO NOT HAVE A MEMBER TABLE
oh, yes you do. You joined "Sponsers" to "Sponsers" and aliased one as "Members". Basically the same thing as having a table by that name.
Last edited by Micron; 11-12-2022 at 03:07 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.