Restricting values in combo boxes

[Remster]

Folks



Here's another one. I promise I'm not planning on carpet bombing this forum with queries.

When adding a combo box to a field in a table, is it possible to restrict the values so that they include only a subset of the entries in the relevant column from the source table?

For example, Column A in Table 1 might contain a list of names, while Column B contains check boxes to state whether the people named are still alive. Column A in Table 2 might then contain combo boxes linking to Column A in Table 1. Would it be possible to restrict the values in the combo boxes so that they contained only names of people who were still alive?

Remster

[ajetrumpet]

Column A in Table 2 might then contain combo boxes linking to Column A in Table 1. Would it be possible to restrict the values in the combo boxes so that they contained only names of people who were still alive?

Remster

you will probably need a WHERE clause in the sql of the lookup function you're using. but...this should never been done at the table level. controls and sql statements do not belong there. see here: http://www.mvps.org/access/lookupfields.htm

[Remster]

you will probably need a WHERE clause in the sql of the lookup function you're using. but...this should never been done at the table level. controls and sql statements do not belong there. see here: http://www.mvps.org/access/lookupfields.htm

Thanks. So is the suggestion that they should be used in a form instead, or should I create an intermediate query?

[ajetrumpet]

Thanks. So is the suggestion that they should be used in a form instead, or should I create an intermediate query?

always in the form. combos are populated with query strings usually

[Remster]

Many thanks.