View Single Post
  #2  
Old May 12th, 2006, 05:47 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Combobox doesn't show what query listed...

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

"..." wrote:

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.