Hi there,
I have a problem where I have a combo box set up on a form which I use as a search field to bring up various invoice numbers.
My problem is that in the search field, there are at times duplicate invoice numbers, but the invoice numbers have different information against them. Both show up in the search field, but even when I select the next record with the same invoice number, the record won't update to reflect the details of that invoice number. I tried adding the ID to display in the combo box as well, but it still doesn't change the information displayed.
If anyone has an answer to this it would be much appreciated!
I have a problem where I have a combo box set up on a form which I use as a search field to bring up various invoice numbers.
My problem is that in the search field, there are at times duplicate invoice numbers, but the invoice numbers have different information against them. Both show up in the search field, but even when I select the next record with the same invoice number, the record won't update to reflect the details of that invoice number. I tried adding the ID to display in the combo box as well, but it still doesn't change the information displayed.
If anyone has an answer to this it would be much appreciated!