Results 1 to 2 of 2

Thread: Search Using Combobox

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Nov 2004
    Posts
    144

    Search Using Combobox

    Hey all,

    I have a combo box that is filled with Appliance_Numbers, what i want to know is how do i use that combo box to filter out the correct data

    Thanks

  2. #2
    Addicted Member
    Join Date
    Jan 2002
    Location
    Glasgow, Scotland
    Posts
    202

    Re: Search Using Combobox

    On afterUpdate of the combo box

    Code:
    DoCmd.ApplyFilter , "[Appliance]=forms!YourFormName!YourComboBoxName"
    if you fail to plan, you plan to fail

Posting Permissions

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



Click Here to Expand Forum to Full Width