adp Parameter

  • Hi Paul,

    Your very welcome.  I'm glad to help.

    A few comments:

    First of all, do debug.print to get the actual SQL that the combo receives.  Is there a space between the SP name and the first quote mark?  Looks to me like the space is missing in all of your SQL statements.

    What version of Access are you using?  If it's 2000, you should upgrade to 2002 or 2003, as 2000 had serious problems.

    Upsizing causes many problems.  It's a black box, and far from perfect, so you have to redo many things by hand.

    Make sure that your combo columns are set up so that you can actually see any data that is retuned.  (I've been fooled by this one a few times)

    Is your event code executing properly?  Put a breakpoint there to make sure it is firing.

    You really don't want to requery every time a user enters the control, do you?  I'm guessing this is just for testing, right?

    Run the SP in Query Analyzer or in the Access SP editor to make sure it returns rows.

    HTH,

    Rich

  • Hi Rich

    Once again thanks for your efforts with this.

    I worked through you logical steps and still surprisingly drew a blank.  Then I discovered the actual problem - the code didn't work from the On Click command.  When I put it into On DoubleClick it worked just fine.  I don't know if this is an Access 2003 bug.....

    I was slavishly following the Acess Projects book I have, which states that the code should be executed from the On Click event - I will be more circumspect from now on.

    I moved the exec code to the subform's On Open event and it works just as it is supposed to do.

    I seem to be doing fine now and making good progress - again thanks to your excellent help.

    I'm sure you'll see me posting again, but for now all is just fine.

    Very many thanks

    Paul

  • Your welcome, Paul.

    I wonder if the event was firing at the proper time (i.e. if the OnClick property was properly set to "[Event Procedure]").  Also, the OnClick event for combos only fires when you actually select an item from the list.  Perhaps that is the problem.  I just tested this with an SP on a combo, and OnCLick works as expected for me, but only when selecting from the list, of course.

    Good luck with your project!

    Rich

Viewing 3 posts - 16 through 18 (of 18 total)

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