Record Source Does Not Exist?

[Nicole]

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 Meyer [MVP]]

Check the spelling of the table or query that is the recordsource.

 

[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

 

[Arvin Meyer [MVP]]

Did you use the Lookup wizard on a table? or was it the combobox wizard in a
form?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Nicole]

I used the Lookup Wizard in a table.

Nicole

 

[Arvin Meyer [MVP]]

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.

 

[Nicole]

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

 

[Nicole]

A better question, I think, would be, how do I undo what's already been done?

Nicole

 

[Arvin Meyer [MVP]]

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Arvin Meyer [MVP]]

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com