Combo Box values on Startup

[Dean Simpson]

I am have huge problems with combo boxes when a form is starting up. The
main problem is when I open a form, the values are not being displayed.

I have 2 combo boxes (Group, Category).
Group is a table with GroupID(Key) and Description
Category is a table with CategoryID(Key),GroupID , Description
Then I have a table (Products ) which has a field CategoryID which links to
the Category Table.
Under relationships they are joined by Group Table to Category Table to
Products Table

I can sync the 2 combos together when the Group changes etc but I cannot get
the combos to display the values when the form opens.
Values are the descriptions in both cbo's
The category combo control source is bound to the CategoryID in the Product
Table

Can anyone help

Thanks in advance

 

[Jeff Boyce]

Dean

Any chance one of those combo boxes is "bound" to your underlying Products
table field? Any chance the form is set for Data Entry?

 

[Dean Simpson]

The Category Combo Box is bound to the CategoryID in the
Product File. This always displays the correct
description, but the Group Combo Box doesn't and this is
where I am having the problems. Here's how I have the
form setup

The forms record source is a query made up from group,
category, products (Tried it with just Products Table)

The form isn't set for data entry

The Group combo is a query on the groups table not bound
to anything

The category cbo is bound to the product file, but the
rowsource is a query on the category table. Am I going
wrong somewhere here and if so can you help?


Thanks in advance

 

[Jeff Boyce]

Dean

Consider making both combo boxes unbound for your "lookup" functionality.

 

[Deano]

Completed Successfully. Thanks for Idea

Surely Microsoft could sort this kind of problem out some other way, it
would seem to be a simple task to do. But I'm sure there's other people
with the same idea for their problems???

 

[Jeff Boyce]

Actually, I seem to recall seeing Knowledge Base articles about using
"chained" combo boxes to select records.

Congratulations on success.

Jeff Boyce
<Access MVP>