Combo Box Selection

[c8tz]

I have a form that has 3 subforms.

The main form has a combobox with selection for Groups. According to
the selection of the Group - the subforms should show info for that
group.

In the Second Subform - this shows Group Details - there is a combo
box for Section - where stock from the group will get transferred to
the selected section. The choice for Section here should also show in
the next subform.ComboBox Section.

As inthe next subform this shows Section Details.

At the moment - the Section Selection in SectionDetails subform is not
updating the value that has been selected. Please help!!
I

I've tried changing the source of the second combobox to equal that of
the first combobox but this does not change until I close the form and
load it again.

The combobox section is based on a query that updates its list and
this is dependent on the selected Group in the MainForm.

Thanks

 

[Steve]

It sounds like you need to requery the SectionDetails subform after you
select the section in the section combobox.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)