Re: combo box problems

franc sutherland wrote:

Hi,

I am using Access 2003. I am having a problem with a pair of combo
boxes. I want the second one (cbo_service) to have it's row source
limited by the value I select in the first one (cbo_supplier). I have
added the criteria in the query for cbo_service that it is limited by
the value selected in cbo_supplier, using the full location of forms!
frm_x!cbo_service. However, when I click on the pull-down, it brings
up the select criteria dialog box. I put in an after update event to
show a message box with the value selected in cbo_supplier, and it
comes up fine. However, the value from cbo_supplier is not making it
to the query for cbo_service in time, if you see what I mean.

The background to this is that I have a main form, called frm_event.
This is based on a table which has the key event_id. In this there is
a subform which is based on a linking table which has the fields
link_id, event_id, supplier_id and service_id. When I type in the
name of the event on the main form, the event_id autonumber comes up
on the main form and is carried through to the event_id box in the
subform. I then go into the subform and select the supplier from
cbo_supplier, and the supplier_id number comes through fine. When I
then go into cbo_services, it asks me for the supplier_id with a
select criteria dialog box. If I remove the criteria, it lists all
the services for all suppliers. I need to limit it to the supplier
just selected in the previous combo box.

All help appreciated!

Thanks,

Franc.

Let's say you have Combo1 in the form MainForm. It's rowsource could be
Select OrderNumber, OrderDesc From Orders

The rowsource for Combo2 might be
Select OrderDetailID, Item, Qty From OrdDetail Where
OrderNumber = Forms!MainForm!OrderNumber

In the AfterUpdate event to Combo1 enter
Me.Combo2.Requery

The requery will synch the 2 together. It's possible your criteria for Combo2 is incorrect or you aren't requerying.

.

Relevant Pages

  • Re: Subform linked to Main form via user login
    ... I must admit that I did not know about the "requery" requirement ... ... On that form I have a subform that is bound via a query that uses the ... If I open the subform with the main form already open I ... If you are using that kind of criteria in the subform's ...
    (microsoft.public.access.formscoding)
  • combo box problems
    ... up the select criteria dialog box. ... I put in an after update event to ... a subform which is based on a linking table which has the fields ... I then go into the subform and select the supplier from ...
    (comp.databases.ms-access)
  • Need to Requery SubForm
    ... I have an unbound field on a main form that provides the criteria for a ... query parameter on the subform. ... Using Requery does the job but it also returns the main form to the first ...
    (microsoft.public.access.forms)
  • Re: combo box problems
    ... up the select criteria dialog box. ... a subform which is based on a linking table which has the fields ...  I then go into the subform and select the supplier from ... So, because the combo boxes are in a subform, the referencing is ...
    (comp.databases.ms-access)
  • Re: Repost - Multiple Combo Boxes
    ... base the Subform on a Query referencing the ... >boxes as criteria: ... >In the AfterUpdate event of each combo, just requery the ...
    (microsoft.public.access.formscoding)