Hi there,
Overview :
I have a form in which I have two union queries with 8 columns (0-8) with each column displaying different info. Both union queries are exactly the same EXCEPT for the 1st query has the account number in the 1st column while the other query has the account number in the 0 column. I then created two combo boxes & linked them to each of the queries along with a couple text boxes to display all the info with the On Change Event (me.patientname.value = me.patientaccount.column(1) & so on.)
Problem :
Duplicates.
Everything works PERFECTLY except for duplicates.
If you type in, lets say 999, in the patient account combo box - it will only bring up one of the accounts. But two accounts have the same number but different names. So if I wanted to select the second '999' it wouldn't change.
Now if you type, Joe Smith, in the patient name combo box - it will only bring up one of the names UNLESS it had something different like a middle initial.
Both comboboxes are bound to column 1 because they work (except for duplicates) when generating a report on the fields names. Otherwise I can get the form to display everything correctly (include duplicates) but not generate right when running the report...
This may sound all over the place so let me know if I can be any more specific.
Thanks!
Overview :
I have a form in which I have two union queries with 8 columns (0-8) with each column displaying different info. Both union queries are exactly the same EXCEPT for the 1st query has the account number in the 1st column while the other query has the account number in the 0 column. I then created two combo boxes & linked them to each of the queries along with a couple text boxes to display all the info with the On Change Event (me.patientname.value = me.patientaccount.column(1) & so on.)
Problem :
Duplicates.
Everything works PERFECTLY except for duplicates.
If you type in, lets say 999, in the patient account combo box - it will only bring up one of the accounts. But two accounts have the same number but different names. So if I wanted to select the second '999' it wouldn't change.
Now if you type, Joe Smith, in the patient name combo box - it will only bring up one of the names UNLESS it had something different like a middle initial.
Both comboboxes are bound to column 1 because they work (except for duplicates) when generating a report on the fields names. Otherwise I can get the form to display everything correctly (include duplicates) but not generate right when running the report...
This may sound all over the place so let me know if I can be any more specific.
Thanks!
