 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007Record Source Does Not Exist?
I'm getting this error message when trying to use one of my combo boxes. The record source does exist. I typed it in my self in the lookup wizard. Please advise. Nicole Check the spelling of the table or query that is the recordsource.  SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > I'm getting this error message when trying to use one of my combo boxes. > The > record source does exist. I typed it in my self in the lookup wizard. > Please advise. > > Nicole Arvin: I'm confused. When using the lookup wizard, I was given two choices. One to "...look up values from table or query." and two to "...type in the values that I want." I chose the latter. It is not clear to me where, other than the field properties, these values are stored. So, how can any mis-spellings be involved? Nicole > Check the spelling of the table or query that is the recordsource. > > I'm getting this error message when trying to use one of my combo boxes. [quoted text clipped - 3 lines] > > > > Nicole Did you use the Lookup wizard on a table? or was it the combobox wizard in a form? SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > Arvin: > [quoted text clipped - 17 lines] >> > >> > Nicole I used the Lookup Wizard in a table. Nicole >I used the Lookup Wizard in a table. And my answer to that is: Don't do it. In spite of the fact that Microsoft allows you to do it, is the wrong thing to do ... ALWAYS. The reasons are here: http://www.mvps.org/access/lookupfields.htm Build a query and use forms (even datasheet forms, if necessary) to edit your data. A user should never see a table or even know of their existence. SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com So, is the combo box wizard in the form a better option? The evil list doesn't suggest that. Or, should I just make another separate table to hold the values I want the combo boxes to offer? Nicole > >I used the Lookup Wizard in a table. > [quoted text clipped - 6 lines] > Build a query and use forms (even datasheet forms, if necessary) to edit > your data. A user should never see a table or even know of their existence. Yes, use the form wizard. Always edit data in forms, not tables. Tables are for storing and maintaining data. For a report, you can link the tables in a query and add the "lookup field" to the query. SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > So, is the combo box wizard in the form a better option? The evil list > doesn't suggest that. Or, should I just make another separate table to [quoted text clipped - 15 lines] >> your data. A user should never see a table or even know of their >> existence. A better question, I think, would be, how do I undo what's already been done? Nicole > >I used the Lookup Wizard in a table. > [quoted text clipped - 6 lines] > Build a query and use forms (even datasheet forms, if necessary) to edit > your data. A user should never see a table or even know of their existence. Not hard at all, the data is probably correct, it's just displayed wrong. First make a copy of the database file (several copies until you get really sure of yourself) then, go into the table design and change the display from combo to text box. Read the Select statement first so you can make similar queries, if necessary. SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com >A better question, I think, would be, how do I undo what's already been >done? [quoted text clipped - 13 lines] >> your data. A user should never see a table or even know of their >> existence. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.