Results 1 to 2 of 2
  1. #1
    PlamenGo is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jun 2011
    Location
    Bulgaria
    Posts
    22

    Change of Combobox value changes Table record ..

    I have a Form displaying data in textboxes from a table - table has too many colums ...., but the Autonumber field I havr named "UNIQ" (to remind me ..). The Table is set as a RecordSource for the table.
    In order to select which record is displayed, I created a Combobox with a Query, Selecting only 3 fields from the table - Name, Description and UNIQ.
    The combo box shows only Name.
    When Selecting a Name from the Combo, I have the code :


    DoCmd.SetFilter , "UNIQ = " & Me.cboxName.Column(2)

    Everything works perfect for the records - I can browse thogh all one by one, but

    Problem!?!:
    The changee of cboxName changes the recorded Name in the Table !
    Example:
    I have 3 records:
    Labels: UNIQ Name Description P1 P2 etc ...
    1 Sec1 Content 100 45
    2 Sec2 Content 65 21
    3 Sec3 Content 121 45
    Record 1 shows correctly, but after I select Record 2, the table content changes to:

    Labels: UNIQ Name Description P1 P2 etc ...
    1 Sec2 Content 100 45
    2 Sec2 Content 65 21
    3 Sec3 Content 121 45
    and if I continue Sec 3 also changes ..

    Can someone explain why is this happening and how can I avoid it?
    regards

  2. #2
    PlamenGo is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jun 2011
    Location
    Bulgaria
    Posts
    22
    Got reply from another forum - The ComboBox was bound to a table field (by chance - my mistake) .. These Comboboxes must be Unbound

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 04-09-2014, 01:45 PM
  2. Replies: 40
    Last Post: 08-20-2013, 11:38 PM
  3. Combobox selection updates Table record
    By lucky in forum Access
    Replies: 4
    Last Post: 10-30-2011, 10:44 AM
  4. change a combobox value depending on another
    By emadaldin in forum Access
    Replies: 3
    Last Post: 01-17-2011, 01:06 PM
  5. Replies: 2
    Last Post: 11-29-2010, 11:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums