combo box problems

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.

.

Relevant Pages

  • 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 ... The requery will synch the 2 together. ...
    (comp.databases.ms-access)
  • 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: change text on tab based on data
    ... Any field in the criteria must be a field in the domain - in this case, ... Although I am not sure what this query is for. ... hand, if you have a query for each subform, then you don't need criteria to ... What I need to do is have each tab where the Record_ID is not null ...
    (microsoft.public.access.formscoding)
  • Re: Specific Search Criteria
    ... Will your findasyoutype code work with a mainform/subform; ... I want to have the main form contain the search criteria boxes and the ... This one serves as an example, showing how to build the code to filter ... The forms record source is based on a query called "qryCandidates" ...
    (microsoft.public.access.forms)
  • Re: Multiple Criteria Search (5+ Search Fields)
    ... I would change the record source of the subform based on the criteria. ... Dim strSQL as String ... Have tried multiple SQL and VB codes for this and can't get any of them to ...
    (microsoft.public.access.tablesdbdesign)