updating combobox in subform based on value in mainform

[tomagneessens]

Hi all, and tx in advance for any help !!


So here it goes :


I have a mainform with adresses and 1 dropdown. What is shown in that
mainform is dependant of the choise in 1st dropdown (location). This
works OK.


In that mainform I have a tabcontrol with in one of the tabs a 2nd
form.


That second form has its own dropdown.


The second form is supposed to show for example doctors for A
specifique location choosen in dropdown 1. And that works OK.


I'm only showing one Docter at the time in that second form (but there
are more than one doctors for one location).


I want to have a list of ALL doctors for ONE SPECIFIC location in that
second dropdown.


I can't get that to work. Now, the second dropdown shows all doctors
without taking the location (from dropdown 1) into account.


How can I resolve this ?


Kind regards

 

[John Vinson]

I can't get that to work. Now, the second dropdown shows all doctors
without taking the location (from dropdown 1) into account.


How can I resolve this ?

Base the second combo box on a Query referencing the mainform location
combo box. Create a Query on the doctor table with

=[Forms]![Yourmainformname]![firstcomboboxname]

as a criterion on the Location. Use this Query as the Row Source of
the doctors combo box.


John W. Vinson[MVP]

 

[tomagneessens]

If I send it to you by mail, can or will you help me ?

My email is in my name