Results 1 to 2 of 2
  1. #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:

    Resolution ID
    Member Name

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts