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

"Nicole" <(E-Mail Removed)> wrote in message
news:4EA85F11-B6C4-4305-A875-(E-Mail Removed)...
> 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


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.

--
Brendan Reynolds

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


"Brendan Reynolds" wrote:

> "Nicole" <(E-Mail Removed)> wrote in message
> news:4EA85F11-B6C4-4305-A875-(E-Mail Removed)...
> > 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
>
>
> 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.
>
> --
> Brendan Reynolds
>