Results 1 to 3 of 3
  1. #1
    avarusbrightfyre is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Sep 2009
    Posts
    60

    Macro Filter not working....

    Ok, this is a little complicated, so here goes:



    Customer Info Form = customer information

    Work Order Sub-Form = a subform within the customer info form that lists all work orders associated with that customer

    Details form = a separate form that should show a detailed list of tasked completed for a given work order number. There is no primary key for this table and form as I need to be able to list several records related to a single record from the "Work Order Sub-form".

    What I want is to be able to double-click on a work order on the "work order sub-form" and have the "Details form" appear with all entries associated with that particular work order number.

    I'm using a macro with a "where" clause to accomplish this (which usually works) but for some reason this set up is causing a pop-up window to appear asking for a work order number (which should already be selected when I click on the work order record, right?), then opens up the form with no information. I have the macro set to filter out all records except the ones that match the work order number of the currently selected record on the "Work Order Sub-Form". Even if I enter the record I want on the pop-up window, the "Details Form" comes up blank, like it's stuck in data entry mode.

    Any ideas? Need clarification?

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Hi

    Can you show us the wording used in the WHERE clause?
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    avarusbrightfyre is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Sep 2009
    Posts
    60
    I figured out another way to do it using a query as the data source for the details form

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Adding Filter Using Macro
    By TxTcher in forum Forms
    Replies: 1
    Last Post: 02-05-2013, 02:16 AM
  2. Filter Not Working
    By BigCat in forum Reports
    Replies: 13
    Last Post: 06-06-2011, 12:48 PM
  3. Filter command not working for subform
    By yes sir in forum Access
    Replies: 15
    Last Post: 10-15-2010, 10:06 PM
  4. Filter By Form not working!
    By Freybourne in forum Access
    Replies: 6
    Last Post: 06-22-2010, 09:41 PM
  5. RunCode in macro not working
    By LilMissAttack in forum Access
    Replies: 0
    Last Post: 05-27-2010, 05:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums