Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    Spokane, WA
    Posts
    81

    Unanswered: Confusing Behavior

    I have a macro set up to open a form based upon a query from a table with the criteria set as Date(), and it works fine.

    I have added an new field to the table called employeenumber with the criteria set at Like[Enter Your Employee Number].

    Through just the query it works ok, when I use a macro to open the form via the query I get a Enter Parameter Value window with "dar_officer.employeenumber" *and* an additional one with "Enter Your Employee Number".

    First of all the filter is not working and why do I get two parameter windows?
    Last edited by jacque427; 03-21-04 at 12:37.

  2. #2
    Join Date
    Mar 2004
    Location
    belgium
    Posts
    290
    i think the query has a problem, it doesn´t understand what you want, or the query doesn´t have any parameters for the wanted fields.

    hope it helps

    greetings emiel

  3. #3
    Join Date
    Sep 2003
    Location
    Spokane, WA
    Posts
    81
    That's where I'm confused, when I run the query by its self, it works ok.

    Just that the macro isn't pulling it out correctly via the form.

  4. #4
    Join Date
    Sep 2003
    Location
    Spokane, WA
    Posts
    81

    Hmmm...

    Could it be that it is because I don't have the field the query is looking for on the form?

    It's in the table, but not on the form.

    I'll test it and let ya'll know.

  5. #5
    Join Date
    Sep 2003
    Location
    Spokane, WA
    Posts
    81
    Found my problem, I was getting too complicated. I just added the criteria to an existing part and it works ok.

Posting Permissions

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