Two Tables - Returning Records

[sgladie@bgsu.edu]

Hello, I am working with two tables in Access 2016.
Table 1: has only one field, called "word" (no primary key)
Table 2: has three fields, one is auto pk, another called "chapter" and a memo field called "text".

I am trying to create a query/form that takes Table 1 "word" value and looks in Table 2 field "text" and returns every record that has the "word" value in it.

I created a form, that uses a combobox to select the "word" from Table 1. Then a listbox with the dataset of Table 2. In the query to the listbox, under critiera for field "text". I have:
="*Forms!frmMain.Combo0*" and on update of selecting the "word" the listbox requeries. But it does not work.

I created a Dlookup in a query, to no avail also.

I can't figure out why. Please help. I think I am over-thinking again and making this harder then it really is. :banghead:

 

[jdraw]

That's HOW you have or are attempting to do something.
WHAT exactly is the something?
Sounds like an assignment---just saying.

 

[sgladie@bgsu.edu]

It is not an assignment, I am helping a friend out. Basically just want whatever value they select from the combobox - which recordsource is from Table 1, field "word"... I want the listbox - recordsource Table 2, field "text" to search through Table 2 and return all records that contains that word they selected. Table 1, field "word" is a text field, Table 2, field "text" is a memo. I would think the wildcards would work!! Thank you.

 

[jdraw]

Here is a free video by Steve Bishop that should describe the process with a keyword to find records in a table or query. He shows entering a word in a textbox and
a) results in a subform, and
b)results in a listbox.

You can change the textbox to a combo etc.


Good luck.