synchronizing two combo boxes

[medinacarlosa]

to any one that can help, I am trying to create a form which has two combo
boxes. The first combo box has a list of categories and the second combo box
would show just items within a category. I have looked at Article ID 97624 &
98660. I have followed the directions very carefully and the second combo
box still shows none of the items. I have created all the tables, queries,
and macros have been very careful in setting up the combo boxes. Can anyone
help?

 

[Steve Schapel]

Medinacarlosa,

Can you please post back with some further information?... The Row
Source of the Categories combobox. The Name of the Categories combobox.
The Bound Column property of the Categories combobox. The Row Source
of the Items combobox.

 

[medinacarlosa]

Hi Steve,

Here's the info you requested:

Name of the Categories combobox: Categories
Bound Column property of the Categories combobox: 1
Row Source of the Items combobox: Category Combo Query

Also, I could email the database to you if it would make things easier. I
couldn't attach it through here though. Thanks.

Carlos

 

[Steve Schapel]

Carlos,

Sorry, it doesn't really tell me anything just to know the name of the
queries. Can you give me the details of the queries that form the Row
Source of the two comboboxes? Either list the fields included in the
queries (or tables), or preferably go to the design of the query, select
SQL from the View menu, and then copy/paste the SQL of the query into
your reply here. Thanks. The Row Source of both comboboxes would help.

Normally it is not advisable to provide the database... sometimes it
could make finding the resolution quicker, but you won't learn as much.

 

[medinacarlosa]

Hi Steve,

Here's the SQL code for the Category Combo Query:

SELECT Issues.IssueID, Issues.Issue
FROM Issues
WHERE (((Issues.Category)=[Forms]![ADAComplianceSurveyForm3]![Categories]))
ORDER BY Issues.IssueID;

 

[Steve Schapel]

Carlos,

Well, this is what I would have imagined was the Issues combobox. But
anyway, how about the other one? Can we see the Row Source of the other
combobox as well?