Results 1 to 3 of 3
  1. #1
    hak is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Posts
    13

    cascade table problems


    i have cascade combo boxes on my logging info form problem is that when i select customer name it shows me all the addresses of that customers but access copies this single address iinto all the fields of the address column. can somebody plz tell me what is wrong?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    What do you mean by 'copies this single address into all the fields' - do you mean every record shows the same address? Are you using VBA to set value of an UNBOUND textbox? If so, then every record will certainly show the same value. Don't use VBA for this. Use expression in textbox ControlSource that references column of combobox.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    hak is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Posts
    13
    thank you so much it was unbound control box

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

Similar Threads

  1. Help with cascade combo box
    By jwalther in forum Forms
    Replies: 2
    Last Post: 06-19-2015, 07:19 AM
  2. Cascade of 3 or more ComboBoxes
    By tomullus in forum Forms
    Replies: 4
    Last Post: 10-08-2011, 06:22 PM
  3. Pivot table problems...
    By netserf in forum Access
    Replies: 1
    Last Post: 08-22-2010, 11:43 AM
  4. Access Table problems
    By Hjava in forum Queries
    Replies: 3
    Last Post: 05-27-2010, 04:35 AM
  5. Linked SQL Server Table Problems
    By jalton in forum Import/Export Data
    Replies: 3
    Last Post: 02-13-2010, 12:52 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