Results 1 to 2 of 2

Thread: How to Filter Records

  1. Mar 8th, 2006, 06:17 AM #1
    nileshhthakur2004
    nileshhthakur2004 is offline

    Thread Starter
    Addicted Member
    Join Date
    Nov 2005
    Posts
    152

    Exclamation How to Filter Records

    Hi all,

    how to Fileter Records in Access ??

    suppose i have one form on which i have one dropDown for CustomerID and one sub form which show product,
    if i select the CustomerID 1 then it should only show all product related that CustomerID = 1 not all records ... how can i do this ??/

    Thanx in advance ...

    Regards,
    Nilesh Thakur.
    Reply With Quote Reply With Quote
  2. Mar 8th, 2006, 10:51 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: How to Filter Records

    Write a SELECT query to display all records where CustomerId equals the dropdown box selection.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width