Hide Duplicates on Combo Box.

[Tomki]

Hello everybody.

I have the form which serve's as a Search Form. On that form I have the combo Box which looks up the datas from a specific table.

The problem is like this:

On the Combo Box I want to look up just for a unique records.

Example:

I have an a table of a personel. On that table I have the fields Name, Second Name, Last Name etc. For that table I h've designed a form where you can enter or view records (called frmPersonel).

I also have the form (called frmSearch) which search's the records from frmSearch on frmPersonel. On frmSerach I have a Combo Boxes to search the records by Name, Second Name, Last Name etc.
What I would like is:
If on the filed Name (frmPersonel) there are 10 people with Name Michael, on the Name Combo Box (frmSearch) to appear just one of them (just one Michael), and when you click on that Name then the database to show you all the Staff(frmPersonel) which Name is Michael. Somehow it is for hiding duplicates records on Name Combo Box (frmSearch) and show all the records relating to that Name.

Can anybody please heelp me???!!

Thank you forward.

 

[Fizzio]

You will need to do 2 things. Initially changing the way you supply the values for the combo box. If you want to search by firstname for example, set the combo to only show the first name of every employee (alternatively you could get clever and use an option box to allow search by forename, surname or any of the fields in your combo) then using either a query to populate the form with all the desired results on or using the openargs property of the form to filter your answers.

 

[Tomki]

Thank's Fizzio.

It worked