Urgently need a reply: How do i filter a form using a combo box in another form

**PianoMan64** · Apr 1 '08, 06:03 AM

Originally posted by viranadim

I am having problems with attempting to filter a form based on criteria
selected in a combo box from another form. I am attempting to filter a form called "Ford CheckList" that is based on a table called "Ford Returned Warranty Parts List". I am using the catagory "Program" that is in a combobox called "Program_Co mbo" which is located on a form called "Ford Database: Choose an Option". I want the user to open the form "Ford Database: Choose an Option" select the program they want from a combobox which in return will open a filtered version of "Ford CheckList" form with respect to that program.

I am new at this so i will need clear and step by step direction. Thank you. Please ask me if this question is not clear.

OK, what you're going to need to do is the following:

If you're wanting to display a list based on the selection of a combo box, that's very easy.

1. In a blank form, create a listcontrol. It's the button next or near the Combox box control that doesn't pull down, it's just simply a list. Make sure NOT to go the full size of the form to the left. It will be creating the name of the control List0: or something like that.

2. Delete the Label that the list control creates.

3. Then drag the left edge of the list control to the left so that you take full advantage of the real estate on the left side of the form.

4. Create a combo box accross the top of the form.

5. If the property window isn't showing on your design mode form, click the property button, or right-click on either one of the controls on the form and select porperties.

6. Go to the control Name and call the Combox Box Program_Combo and call the List Control Ford_List

7. Then we're going to need to create a command button on the form. If you have the wizard turned on when you create this button, just simply click on cancel. This will create the button with Command#.

8. Name the command button SearchBtn.

Ok, now we need to create the code that is going to create the list of parts.

Since I don't know the exact table structure, It's kind of hard to continue, if you're wanting step by step instructions.

If you'll send me table structure and example data of what's in the table and how you want to filter it, I can finish the rest of it.

Hope that helps,

Joe P.

Urgently need a reply: How do i filter a form using a combo box in another form

Urgently need a reply: How do i filter a form using a combo box in another form

Comment