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
LVL 7
COACHMAN99Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
PatHartmanConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.