Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unwanted list flicker (MS Access 2004)

    I have a listbox on a subform. Its rowsource is:

    SELECT TXMASTERS.ID1, TXCLIPS.ID2, " " AS Persons, TXCLIPS.NName AS Name, TXCLIPS.Comments, TXCLIPS.Start AS [Time In], TXCLIPS.End AS [Time Out], TXCLIPS.ID1
    FROM TXMASTERS INNER JOIN TXCLIPS ON TXMASTERS.ID1 = TXCLIPS.ID1
    WHERE (((TXCLIPS.ID1)=[FORMS]![Mainform1].[FORM].[ID1]))
    ORDER BY TXCLIPS.ID2 DESC;

    ie it gets filled with records that have the matching ID1 which is the parent table/Form primary key.

    On the onclick event on the list I have:

    Dim RS2 As Recordset
    Set RS2 = Me.RecordsetClone
    Me.RecordsetClone.FindFirst "[ID2] = " & Me![list]
    Me.Bookmark = RS2.Bookmark

    Which makes the subform filter to the record matching ID2 loaded into the list.

    The subform is bound to the table TXClips.

    When the list is clicked the first time all is okay, the subform record is coorect. However further clicks on the list cause the list to flicker badly almost as though its refreshing. The Bookmark code seems to cause the problem? There is no other code in other events ie oncurrent etc to do anything Any ideas? Thanks

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

    Re: Unwanted list flicker (MS Access 2004)

    Does it help if you add the following line at the beginning of the On Click event procedure of the list box?

    Echo False

    and the line

    Echo True

    at the end (before End Sub)?

  3. #3
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unwanted list flicker (MS Access 2004)

    Thanks Hans, but no it did not cure it. It seems strange that on the first click of the list its okay, but further clicks cause the list to look like its being refreshed. If I remove the bookmark code the list does not flicker. Regards

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

    Re: Unwanted list flicker (MS Access 2004)

    Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  5. #5
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unwanted list flicker (MS Access 2004)

    Assuming you mean Access 2003 - I do recall a similar issue with sub-forms and filters. Service Pack 1 cured it.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

Posting Permissions

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