Thread: Recordset Problem (2000)
2003-03-21, 16:11 #1
- Join Date
- Mar 2003
- Thanked 0 Times in 0 Posts
Recordset Problem (2000)
I have a table that keeps track of board meeting votes. I have the following fields:
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2003-03-21, 16:36 #2
- Join Date
- Mar 2002
- Thanked 16 Times in 16 Posts
Re: Recordset Problem (2000)
If only one member can motion a resolution, you shouldn't have a Motioned? field in this table. It contains a lot of redundant information.
Instead, you should have a field MotionedBy in the Resolutions table. This field should be linked to the MemberID field in the Members table (i.e. the primary key in the Members table.)
This means that Motioned? must also be removed from the subform. Instead, put a combo box on the main form bound to the MotionedBy field, with the Members table as row source.
As a consequence, you don't need to check for multiple members who motion a resolution - the MotionedBy field can contain only one MemberID.
Some remarks on your code:
If rst.NoMatch Then
MsgBox "No County Board Members have been added."
rst.Delete **This Doesn