I'm getting this error message when trying to use several of my combo boxes.
"The record source does exist..." I typed in the data myself in the lookup
wizard from within my table's design view. To try to trouble shoot, I
created my record source as a unique table (entries collected by way of
form), and then redefined the record source as this new table for those
troublesome fields. Still no change. My first method is working fine in
combo boxes 1-4 which are the same type as 5 and 6, the ones with the problem.
I was advised not to use the lookup wizard in the table because of the
following article.
http://www.mvps.org/access/lookupfields.htm
However, I have not been able to find problem number one with the fields
that I am having issues with. I am having problem one with some other fields
that are working fine.
Now I'm just all confused about how I can set some combo boxes and get them
to work properly. Why does everything in Access have to have a theory behind
it that you must first understand in order to get seemingly simple,
established controls to work?
Please advise.
Nicole
> I'm getting this error message when trying to use several of my combo
> boxes.
[quoted text clipped - 26 lines]
>
> Nicole
One thing you could try is to check that the Row Source Type is set
correctly. If the Row Source property contains the name of a table or a SQL
statement, make sure that the Row Source Type is set to Table/Query. If the
Row Source property contains a list of values, make sure that the Row Source
Type is set to Value List. I just checked, and if I create a combo box and
use a value list as the Row Source but set the Row Source Type to
Table/Query, I get exactly the error message that you describe.

Signature
Brendan Reynolds
Nicole - 21 May 2007 21:01 GMT
Brendan:
Everything was as it should be. But you know, this turned out to be one of
those situations where the issue could be resolved by just deleting the
fields in design view and reinstalling the. They work fine now. Thank
goodness there was no data input into those fields yet. Thanks for reviewing
my case.
Nicole
> > I'm getting this error message when trying to use several of my combo
> > boxes.
[quoted text clipped - 34 lines]
> use a value list as the Row Source but set the Row Source Type to
> Table/Query, I get exactly the error message that you describe.