Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Recordset Update (2000)

    Hello I have a list of users in a combo where those users come from two different tables and the source of the combo is a union query. I have now discovered that the record for any users in one of the under lying tables cannot be updated yet is can on the other. Is there a way around this or is it a nuance of a union query?

    Thanks Darren.

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

    Re: Recordset Update (2000)

    A union query is never updateable, but the record source of the form is not necessarily the same as the row source of the combo box. Whether the records in the form are updateable depends on the record source.

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Recordset Update (2000)

    Thanks Hans, the row source for my combo is the union query with the two tables of names providing the data for the union, control source is a field in the record source table of the form. I cannot understand therfefore why the records with a name from table 1 is updatable but not table two, any thoughts?

    Thanks.

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

    Re: Recordset Update (2000)

    Darren, the row source of the combo box only determines what is displayed in the dropdown list of the combo box, it has nothing to do with whether records can be updated or not. What matters is the record source of the form; I presume this is a query. You haven't told us anything about this query yet.

  5. #5
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Recordset Update (2000)

    Hi Hans, record source of the form is a table. I would zip a version but their is too much on it. Strange thing is when I delete the majority of records all works fine. the table record source of the form is the many side of a one to many relation.

    Thanks Darren.

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

    Re: Recordset Update (2000)

    If the record source is a table, I don't understand what you mean when you say that some records are not updateable. Do you mean that you can select only some of the items in the combo box?

  7. #7
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Recordset Update (2000)

    No, I am puzzled. There are certain records that won't allow me to update any fields be it the drop down or other parts of the record.

    Darren.

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

    Re: Recordset Update (2000)

    Is that before or after you select an item from the combo box?

  9. #9
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Recordset Update (2000)

    Both, sorry, Iam trying to get a zip to you but each time I strip it down my problem is solved!

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

    Re: Recordset Update (2000)

    You wrote that only some records cannot be updated. Can you leave those in the stripped down copy?

  11. #11
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Recordset Update (2000)

    Darren,
    When you select a record from your combo box that is from the table that is *NOT* the Record Source of the form, what happens?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  12. #12
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Recordset Update (2000)

    Hello again, I have realised what the problem is, fundamental point for which I apologise for not noticing, the issue only occurs when I have filtered to a record and indeed each record becomes not updatable, not just some. So there is the reason, not sure how to resolve still?

    Thanks Darren.

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

    Re: Recordset Update (2000)

    Do you have code for the After Update event of the combo box? If so, can you post the code here, please?

  14. #14
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Recordset Update (2000)

    Here is a stripped version. Password is perthwa, go into main form and it is on filtered records I cannot update?

    Thanks Darren.

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

    Re: Recordset Update (2000)

    I see a combo box Combo60 that can be used to search for a record; I don't see a combo box that can be used to filter records. Which combo box do you mean?

Page 1 of 2 12 LastLast

Posting Permissions

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