update/refresh combo box 1

[jozino01]

hi,
i have three combo boxes - combo0/country, combo2/state, combo4city - populated by queries:

SELECT [MyData].[Country]
FROM MyData
GROUP BY [country];

SELECT MyData.[St-Prv], MyData.Country
FROM MyData
GROUP BY MyData.[St-Prv], MyData.Country
HAVING (((MyData.Country)=[forms]![form1]![combo0]));

SELECT MyData.CITY, MyData.[St-Prv], MyData.[ZIP-Postal], MyData.Country
FROM MyData
WHERE (((MyData.[St-Prv])=[forms]![form1]![combo2]));

i want to update content of combo boxes for state/city based on content of combo box for country/state. right now it works only at start (first time), after that content doesn't change.

thanks

 

[Remou]

You should requery each of the combo boxes in the current event of the form:

Me.Combo2.Requery

 

[jozino01]

excellent, thank you.

can i have one more question - i have one subform with record source the following query:

SELECT MyData.CITY, MyData.[St-Prv], MyData.[ZIP-Postal], MyData.Country
FROM MyData
WHERE (((MyData.[St-Prv])=[forms]![form1]![combo2]));

i want the content of this subform populate/change based on content of combo box combo4. right now is always blank.

 

[jozino01]

oops, sorry.
this is the correct query

SELECT MyData.CITY, MyData.[ZIP-Postal], MyData.SNOW_PSF, MyData.WIND, MyData.SEISMIC_ZONE, MyData.FROST_LEVEL, MyData.Contact, MyData.Phone_1, MyData.Phone_2, MyData.Note
FROM MyData
WHERE (((MyData.CITY)=[forms]![form1]![combo4]));

 

[Remou]

I suggest that you set the link master field to Combo4 and the link child field to City. The query then should be:

[tt]SELECT MyData.CITY, MyData.[ZIP-Postal], MyData.SNOW_PSF, MyData.WIND, MyData.SEISMIC_ZONE, MyData.FROST_LEVEL, MyData.Contact, MyData.Phone_1, MyData.Phone_2, MyData.Note
FROM MyData[/tt]

You should check that the bound column of the combo has the right data to match city.

 

[jozino01]

thanks.
it looks like the following code works properly with the original query.

Private Sub Combo4_Change()
Form2.Requery
End Sub