Table combobox search and table lookup

[uresan]

Hello,



I'm new to access and also to that forum. If theme or place is not appropriate for my question please let me know.

I came to a issue where I can't find solution that I want.

My desired workflow is that combobox fills with all results that contain morpheme.




For instance. When I write "art" I want to get all restults that contain word "art" and when I select one, for instance 1002, that number 1002 is written to column ARTIKEL and word "Article3" is written to column NAME.

Thank you for your help in advance.

Best regards,

[orange]

Welcome to the forum uresan!
There are Similar Threads at the bottom of the page that may offer some insight.
If not, then I suggest you copy your related code and post it directly in a post.
The more detail/context you provide could facilitate focused responses.

[uresan]

Hello, thank you for your answer.

I think it would be helpful if I provide you with photo. See enclosed.

PS. I already solved part to fill "Article3" to column NAME.

[orange]

Often better to post actual code where readers can see and copy/test. A graphic is helpful for overall context, but field values etc can not be copied and or tested.

I think you are working with the columns of the combobox rowsource in your AfterUpdate logic, but that's just a guess since we can't see any code involved.

Is there still an issue or have things been resolved?

[Welshgasman]

Wouldn't it make more sense to match the numeric to the article numbers?, so 1001 is Article1, 1002 is Article2 etc

[Micron]

According to the icon I see in the pic header, that is a table and the list is a table lookup field. Post title indicates that too, so isn't the right answer to not use lookup fields in tables?

[orange]

micron,

You are most likely correct when I look at this thread again. Still, as has been preached for years, posters should provide some context including "what" they are trying to "solve". Agree 100% avoid field lookups in tables.

But I did find a new word and meaning.
A "morpheme" is a short segment of language that meets three basic criteria: 1. It is a word or a part of a word that has meaning. 2. It cannot be divided into smaller meaningful segments without changing its meaning or leaving a meaningless remainder.

@uresan
You may find this thread a related interest.