how can i limit to a list on a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i set the properties for a lookup column on a table so that the values
i enter for that field have to be listed on the list box?
--
 
In general, you should not define a lookup in your table. Do it in your
forms. There is a setting in the properties for "limit to list".
 
how do i set the properties for a lookup column on a table so that the values
i enter for that field have to be listed on the list box?
Click to expand...

You can't.

The Lookup feature in table datasheets is of VERY limited utility.
This is one of the limitations.

Instead, use a Form; set the RowSource property of the listbox to a
query selecting the values from the table. If values repeat in the
table, set that query's Unique Values property to Yes.

John W. Vinson[MVP]
 
Back
Top