Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2007
    Posts
    4

    Unanswered: why does it prompt for an existing field value?

    Hi folks,

    I have a form based on table. In it I have a combo box that looks up values from another table. A second combo box uses the values from the first combo in order to select its contents....so far so good and everything works fine when I add some VBA to requery the 2nd combo results after the first is updated.

    However, when I close the form a Box pops up with the jolly title of:
    Enter Parameter Value - asking for the contents of the first combo box.
    (which I used as the criteria of the sql to select the contents of the 2nd combo box)

    Now I've added these form elements via the wizards, and for the sql field criteria I used the expression builder - so surely this means that access can't have misplaced the form value.....er right?

    Any ideas as to what's causing this? It's driving me nuts!
    Rob.

    -I'm using Access 2000 on winxp

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Hmm...

    In this case it might be worth you sending a cut-down & zipped version of your db up.
    Create a new database and then export the relevant forms/queries/tables into the new database. Zip the file and upload it here
    George
    Home | Blog

  3. #3
    Join Date
    Aug 2007
    Posts
    4

    fixed by importing into a new db!

    Hi - and cheers for the reply, I had to step out for a bit before i could start at your suggestion.

    Anyways, I imported the forms/tables etc to a new db and tried again...and this time it worked. Very strange, very confusing - a perfect introduction to anything eh?
    Rob.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    How odd!
    Sounds like a compact and repair would fix the badger then!
    If not, continue with your import into a new db and jobs a goodun'!
    George
    Home | Blog

Posting Permissions

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