Not getting lookup prompt in subform column ?

  • Thread starter Thread starter David
  • Start date Start date
D

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
 
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?
Click to expand...

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.
 
Back
Top