?
Solved

ShowOnlyRowSourceValues vs Limit to List

Posted on 2014-03-18
2
Medium Priority
?
2,370 Views
Last Modified: 2014-03-18
Hi All
quick question:
Anyone have a simple answer as to the difference between
ShowOnlyRowSourceValues and Limit to List in Access comboboxes?
thanks
0
Comment
Question by:COACHMAN99
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 39

Accepted Solution

by:
PatHartman earned 2000 total points
ID: 39937501
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
 
LVL 7

Author Closing Comment

by:COACHMAN99
ID: 39937511
excellent - thanks
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question