Combo box acting funny

[Nicole]

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

 

[Brendan Reynolds]

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.

 

[Nicole]

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