Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    May 2004
    Location
    Asheville, North Carolina, USA
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subform Entries (2000)

    Greetings,
    I am creating a Key Roster to show Who has What Keys. Attached is my FILE. My problem is I cannot enter any data into the subform for each individual. Other wise this is work great for me.
    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subform Entries (2000)

    There is no unique key on the KeyTypeID field in tblKeyTypes. As it stands now, you can't create such an index, because KeyTypeID = 80AA occurs twice.
    - Remove one of the two records with KeyTypeID = 80AA.
    - Switch to design view.
    - Make KeyTypeID the primary key.
    - Save the design of the table.
    Your query qry_KeyIssue and the subform should be updatable now.

  3. #3
    Star Lounger
    Join Date
    May 2004
    Location
    Asheville, North Carolina, USA
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subform Entries (2000)

    Hans,
    I over looked the double entry. I corrected that and made the primary key, now when I go to the form/subform it does not show keys that have been issued where before it did. For example: I go to HUMPHREY on the pull down list once chosen it should show what keys are issued to that person. Before changes it did, now it does not.
    Any ideas?? Thanks.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subform Entries (2000)

    You have set the Data Entry property of the subform to Yes, so it will only let you add new records. Set the Data Entry property to No to see existing records.

Posting Permissions

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