Results 1 to 5 of 5
  1. #1
    LucLc is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    May 2016
    Posts
    3

    combobox not working


    hello
    i run an access database build in acc2003 with several users in a network
    one of the users upgraded his application to acc2010
    on one of the forms a combobox isn't working anymore
    combobox has an "after update" event to search for a reccord
    for the other users using acc2003 the combobox works fine

    anyone ??

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    You'll have to give us a lot more information than that. What does "not working" mean? Do you get an error message (if so, what is it), does it find the wrong record, or no record at all?

    What is the row source for the combo box, what columns does it show, and what is the bound column?

    Please also post the After Update code of the combo.

    We can't help you without knowing where to start.

    Thanks

  3. #3
    LucLc is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    May 2016
    Posts
    3
    combobox has 3 rows
    1 bound column
    row source = query
    after update event =

    Private Sub Combo24_AfterUpdate()
    ' Find the record that matches the control.
    Dim rs As Object


    Set rs = Me.Recordset.Clone
    rs.FindFirst "[ID] = " & Str(Nz(Me![Combo24], 0))
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark
    End Sub

  4. #4
    LucLc is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    May 2016
    Posts
    3
    the after update event is not working in acc2010
    no error messages displayed

  5. #5
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Try using:

    If Not rs.nomatch Then Me.Bookmark = rs.Bookmark

    The nomatch property is set to True if the Findfirst does not find a record.

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

Similar Threads

  1. Nz null not working in report from a combobox
    By caniread in forum Reports
    Replies: 2
    Last Post: 02-12-2016, 10:48 PM
  2. Combobox Query not working
    By ntaylor95814 in forum Forms
    Replies: 0
    Last Post: 04-15-2014, 04:29 PM
  3. Replies: 5
    Last Post: 03-21-2013, 04:37 PM
  4. vba code not working with combobox
    By bopsgtir in forum Programming
    Replies: 9
    Last Post: 02-24-2011, 11:27 AM
  5. combobox.dropdown event not working after error
    By perlyman in forum Programming
    Replies: 1
    Last Post: 04-02-2010, 06:55 PM

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