Not getting lookup prompt in subform column ?

[David]

I have a split database, this table column has a lookup
query defined. Whan I open the table in the backend and
click in the column I see the selection list.

In my front-end, I have a subform which displays this
table as a continuous form. When I click in the column I
don't get the lookup list. I need it. Any clues?

- David

 

[John Vinson]

In my front-end, I have a subform which displays this
table as a continuous form. When I click in the column I
don't get the lookup list. I need it. Any clues?

Simply use the Toolbox combo box tool to create a combo box on your
(sub)Form, bound to the field, using the lookup table as its row
source.

Table lookup fields are unnecessary, add complication to your tables,
waste resources (redundant indexes), and in general are far more
trouble than they're worth.