Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Limit To List Problem!

Status
Not open for further replies.

sera

Technical User
Jun 29, 2000
360
US
Hello,
I have a combobox on a form that is getting its list from a table of values. I have the limit to list property set to no. It is not letting me enter data that is not in the list. I am not having this problem on any other form, but it is important to note that the form I am having the problems with is the parent form. Has anyone run across this problem before? Thank you very much for your help!
Sera
 
Sera, From MS Access Help:

If the first column displayed in a combo box is not the bound column, Microsoft Access limits the entries to the list even if the LimitToList property is set to No.
 
Unfortunately this is not my problem! The column the list is drawing from is the only column in the table. I tried messing around with the bound column values and it does not help. I am not having this problem on any of the other associated forms, just the parent form...I don't know if that matters any...
Sera
 
It was a relationship issue. You know how those can be! I had a stupid relationship. Well I've had many but I guess that is for a different forum! Thanks anyway!
Sera
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top