Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2007

Tip: Looking for answers? Try searching our database.

Combo box acting funny

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nicole - 21 May 2007 18:27 GMT
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 - 21 May 2007 19:29 GMT
> 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.
 
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.