Results 1 to 3 of 3
  1. #1
    AndyC121 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    37

    ComboBox not showing data after entry into another record

    if you select a customer the second combo generates parts only for that customer, this seems to work okay and saves the data to my table. Move to a new record and select another customer and part, then when you scroll through records the second combo doesn't show previous selections in records. why? I have looked at row source type (set to table/Query) tried setting data entry to yes
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if you manually pick a customer, the parts list gets refreshed. Ok
    if you move to a record, with no parts entered, the record doesnt know it changed, so,

    in the form ONCURRENT event, refresh the list
    Code:
    sub form_onCurrent()
    Me.cboProduct.Requery
    end sub

  3. #3
    AndyC121 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    37
    great, thank you seems to have done the trick.

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

Similar Threads

  1. Replies: 2
    Last Post: 06-20-2017, 11:57 PM
  2. Replies: 9
    Last Post: 03-01-2017, 10:00 AM
  3. Replies: 3
    Last Post: 12-29-2014, 01:04 PM
  4. Replies: 5
    Last Post: 03-09-2014, 07:16 PM
  5. Replies: 23
    Last Post: 02-09-2011, 10:56 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