"lookup" list in a query

[BudMan]

I created a table with a “lookup” field that gets its value from another table. That works fine.

Now, when I create a query on that field, I need to enter the data into the query directly. The problem is that I do not always remember the exact spelling or name I am looking for. I would like to have a pop-up list appears that I could use to pick the data from. I know I can use something like [enter name] in the query box, but that is not what I want. I want a pop-up list like the one that appears when I manually add data to the field.

First, I hope I explained this correctly, and two, is it possible?

Thanks!

[Bob Fitz]

I would advise against using lookups in tables. Use lookups in forms.
I would advise against using queries to manually enter data. Use forms for data entry.

EDIT:
Perhaps you should have a form bound to the data in table1.
Have on that form a combo box bound to the field in table1 that you currently have a lookup.
The combo box would use the lookup table for you to select from.

See: http://access.mvps.org/access/lookupfields.htm

[ranman256]

If you have a combo box, bound to a datalist as source data to pick,
then start typing in the box, the selection should jump to the value as you type.

If you want a textbox to filter a 'fuzzy list' use this code:

the combo box cboRoomSize
has a list of all room sizes to pick from via qry: qsRoomSizes1Type
use the textbox to narrow down the combo box...
here the fuzzy search text box to enter is: txtSizeFind
enter 43
this will then filter the combo box with only sizes that have 43 in the value:

sub txtSizeFind_Afterupdate()
If IsNull2(txtSizeFind) Then
   cboRoomSize.RowSource = "qsRoomSizes1Type"
Else
   sSql = "select * from qsRoomSizes1Type where [size] like '" & txtSizeFind & "*'"
   cboRoomSize.RowSource = sSql
   cboRoomSize.Requery
    
      On Error Resume Next
    cboRoomSize.SetFocus
    Me.cboRoomSize.Dropdown  'show user the choices
End If

[ssanfu]

See The evils of lookup fields in Tables