Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Washington, DC
    Posts
    116

    Red face Unanswered: filter on click event

    I'm trying to create an on click event that will apply a filter to the recordsource. I'm not receiving any errors, but the data comes up blank when I know there are existing records. It's probably simple, but I can't find anything in my books or this site.

    DoCmd.ApplyFilter , "[L_Name]='A*'"

  2. #2
    Join Date
    Sep 2003
    Location
    Washington, DC
    Posts
    116
    Fixed my own problem!!! Should have read:

    DoCmd.ApplyFilter, "[L_Name] Like 'A*'"

Posting Permissions

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