Post reply

SubForm Weirdness

  • June 12, 2005 at 10:58 pm

    #69106

    Has anyone experienced subForms which occasionally revert to display every record instead of just the records related to the current record on the main form?

    Let me know if you want more details, but I was just wondering what people's experience was.

    Thanks.

    Aaron

  • June 13, 2005 at 7:26 am

    #564967

    Many things can cause this in access.

    One of the most annoying thing I find in access is the urge to save every little value of each paramter of each control and redisplaying them the next time the form opens.

    Are you sure all the input parameters/where conditions are the ones that should be there?

  • June 13, 2005 at 8:02 am

    #565010

    Well, I think so.  The thing is I got it to work, it's just klunky.  The way I got it to work was

    1) Changing the Record source of the main from from the query it was based on to a single table (the table on the left side of the LEFT JOIN)

    2) Adding the subform

    3) Changing the Record Source BACK to the original Query.

    Still, I have to save periodic versions of the form, because if I do a bunch of stuff to it, it may suddenly revert to the subform displaying all records.

    Thanks.

    Aaron

  • June 13, 2005 at 8:09 am

    #565011

    Can you run the profiler and see what query is ran when that happens?

  • June 14, 2005 at 6:49 am

    #565261

    I get this occasionally in just one subform in A97.  Compacting normally corrects it to showing only related records again.

  • June 14, 2005 at 6:57 am

    #565267

    In the same line.. I often resort to decompiling the whole project and recompiling to correct bugs like this.

    It sure helped me a lot in the past.

  • June 15, 2005 at 5:13 pm

    #565936

    Thanks guys.  This has been pretty much resolved.  Access XP is kinda quirky in its implementation of VB.  Anyone else noticed that?

    Aaron

  • June 16, 2005 at 8:05 am

    #566100

    Noticed it with Access 2k .

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply