Results 1 to 3 of 3
  1. #1
    Gabriel2012 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Nov 2012
    Posts
    31

    Query "Where" Clause

    Hello, I have a query that returns data from a table comparable to the same data existing in a combo box from a form. This query has a simple [forms]![frmtbl1on1]![combo62] in the criteria field of the "EMP_ID" in design mode. When I execute this query seperately, it works correctly and only returns the records from the table in which the EMP_IDs from the table and form match

    However, when I execute this query as an "After Update" function, located in the form containing Combo62, the query runs and returns zero records.

    Yes, the bond column for Combo62 is set correctly to the ID.

    Any help would be appreciated, thanks.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Can you show us the query SQL and any vba related to the After Update Event of combo62?

  3. #3
    Gabriel2012 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Nov 2012
    Posts
    31
    Thanks for the reply Organe, here you go...

    Click image for larger version. 

Name:	untitled.JPG 
Views:	4 
Size:	31.4 KB 
ID:	11912Click image for larger version. 

Name:	untitled1.JPG 
Views:	3 
Size:	6.2 KB 
ID:	11913

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

Similar Threads

  1. "AND" or "&" in the FROM clause of a query
    By kelann in forum Queries
    Replies: 21
    Last Post: 11-09-2012, 08:41 AM
  2. Export "Query or Report" to a "Delimited Text File"
    By hawzmolly in forum Import/Export Data
    Replies: 3
    Last Post: 08-31-2012, 08:00 AM
  3. Replies: 1
    Last Post: 08-23-2012, 08:32 AM
  4. Custum Functions in Query "WHERE" Clause
    By trb5016 in forum Queries
    Replies: 1
    Last Post: 02-15-2012, 03:30 PM
  5. Report "WHERE" clause not working
    By rsearing in forum Reports
    Replies: 4
    Last Post: 05-26-2009, 02:07 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