View Single Post
  #1  
Old May 12th, 2006, 12:04 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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.