Combobox doesn't show what query listed...

[...]

Hi,

I have next problem:
I have two comboboxes on form. Dependant on choice in first combobox, query
should list certain values from table (this is working ok - when I open
query after choosing a value in combobox, all values are listed there).
Another combobox should show values that query listed (this is not working).
What could be wrong?

If I choose first item in combobox No1., then combobox No2. shows only first
thing listed in query. In all other cases, Combobox No2 doesn't show
anything.

RowSourceType...Table/Query

Row Source...SELECT [qryPloIzd].[Oznaka], [qryPloIzd].[Materijal] FROM
qryPloIzd WHERE ((([qryPloIzd].[IDplocice])=[Forms]![frmIzd]![Combo4]));


Thanks in advance.

Best regards,
Stole.

 

[Guest]

I think you need and AfterUpdate event or macro to requery.