How to use a combo box to filter a forms data

[tmd63]

I have a table that has a Part Number field. I wish to filter a form by using a combo box. I want to have the combo box display the part number of the entry and then filter the item using the part number, adding either <All> and <NEW> to the list to allow selection.
Is this possible? Or do I have to use a separate Part field?

 

[Gasman]

You would need an unbound combo.
Use a union query to add your extra values All being 0 Autonumber
Then in the AfterUpdate event of the combo set the filter accordingly.

 

[theDBguy]

You could start with using the combobox wizard and selecting the third option. I would suggest using two separate buttons to clear the filter (All option) and going to a new record (New option).

 

[Uncle Gizmo]

This solution on my website might be a bit too comprehensive, but it might give you some ideas of how to go about it..

There is a nice little function, which you might be able to employ....

Combo Filter < All> or Some - Nifty Access

Combo Filtering You can set this up yourself by following the instructions below, or you can study the example file which can be downloaded from the Nifty Digital downloads site for a few dollars.. will normally appear as the first entry in your list because the angle bracket puts it at the...

niftyaccess.com