I have a table with a Name column that is critical to populating the other columns from lookup tables ...
But the Name has to be a 100% match to its own lookup table ...
So I have implemented a dropdown in the Name column that will not allow manual entries and must match an entry in the Name lookup table ...
But ... there are over 200 Names and I would like to implement autocomplete to avoid users having to scroll ... and scroll ... and scroll ...
I've tried a Combo Box (ActiveX Control) but as far as I can see this only allows me to populate a predetermined cell ie I can't apply it to every row in my table (hope that makes sense?) ...
Is there any other way to implement autocomplete for a dropdown list that I've missed?
Thanks ...
But the Name has to be a 100% match to its own lookup table ...
So I have implemented a dropdown in the Name column that will not allow manual entries and must match an entry in the Name lookup table ...
But ... there are over 200 Names and I would like to implement autocomplete to avoid users having to scroll ... and scroll ... and scroll ...
I've tried a Combo Box (ActiveX Control) but as far as I can see this only allows me to populate a predetermined cell ie I can't apply it to every row in my table (hope that makes sense?) ...
Is there any other way to implement autocomplete for a dropdown list that I've missed?
Thanks ...