• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2767
  • Last Modified:

ShowOnlyRowSourceValues vs Limit to List

Hi All
quick question:
Anyone have a simple answer as to the difference between
ShowOnlyRowSourceValues and Limit to List in Access comboboxes?
thanks
0
COACHMAN99
Asked:
COACHMAN99
1 Solution
 
PatHartmanCommented:
Show only values that match the current row source when Allow Multiples Values is set to Yes.
As you can infer by the definition, this only applies to multi-value fields.  Limit to list prevents values that are not in the list from being added so the two properties are not related at all.

Help entry - http://office.microsoft.com/en-us/access-help/add-or-change-a-lookup-column-HA010163773.aspx
0
 
COACHMAN99Author Commented:
excellent - thanks
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now