Unanswered: Combo Box used as a Record filter - Can't filter on duplicate records!
I was wondering if anyone could help out.
I have a Main form which includes elements from table1 in textfields on the Main form for example:
I also added a comboBox to the Main form to use as a filter.
In the combo box the row source is a Query:
SELECT table1.Firstname, table1.Firstname, table1.Lastname FROM table1 ORDER BY table1.Firstname;
(notice table1.Firstname is repeated, the filtering stops working if i change it)
The search filter works great until I have two records with the same firstnames. When I try to select a person who has a duplicate firstname in the system only data from one person shows. If I try selecting the next person with the same name, a refresh happens only to show the same record data.
I cannot seem to see different data if the first names are duplicate.
Here is the AfterUpdate on the ComboBox filter:
Private Sub Combo21_AfterUpdate()
'Moves to Customer Name text box and
'finds the record of whatever name is selected in the combo box
'Set value of combo box equal to an empty string
Me!Combo21.Value = ""