If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
creteria macros | sierralightfoot | Running & Setting Up Queries | 13 | March 8th, 2006 06:13 AM |
Access shuts down, when i try to save this query | Dann | Running & Setting Up Queries | 12 | February 3rd, 2006 02:49 AM |
SQL query showing diff between actual and budget | Bon | Running & Setting Up Queries | 3 | August 25th, 2005 12:07 PM |
Show count if zero | LMB | Running & Setting Up Queries | 1 | August 4th, 2005 09:18 PM |
Nested in-line Query | laura | Running & Setting Up Queries | 0 | February 11th, 2005 12:17 AM |