B
Bob A.
Hopefully the following is a sufficient amount of data to explain. I am
using a combo box (it is a lookup wizard) in a sub form. Its Row Source is
now set to a query. I want to limit the combo box "choices" based on the
main form's data.
When running the query, by itself, it will ask for the parameter (my QBE
criteria), to which I am trying to limit the choices, from the main form.
Once the parameter is entered the query will display the correct data.
When opening the sub form, by itself, the parameter request prompts (that's
okay). Then, all of the sub form rows come up (sure), but only the records
having data matching the parameter will display a value (correctly
functioning?). I can accept that, if necessary, since this sub form is not
meant to be worked by itself. The combo box pull down only displays the
proper selections - very good.
When opening the main form, the parameter request does not prompt. That is
as expected (I wouldn't want to have to enter it). The sub form will display
the proper items. However, in my combo box, records matching only one
parameter will display, so the rest are blank. The combo box value don't
change based on the query parameter. What could be wrong?
using a combo box (it is a lookup wizard) in a sub form. Its Row Source is
now set to a query. I want to limit the combo box "choices" based on the
main form's data.
When running the query, by itself, it will ask for the parameter (my QBE
criteria), to which I am trying to limit the choices, from the main form.
Once the parameter is entered the query will display the correct data.
When opening the sub form, by itself, the parameter request prompts (that's
okay). Then, all of the sub form rows come up (sure), but only the records
having data matching the parameter will display a value (correctly
functioning?). I can accept that, if necessary, since this sub form is not
meant to be worked by itself. The combo box pull down only displays the
proper selections - very good.
When opening the main form, the parameter request does not prompt. That is
as expected (I wouldn't want to have to enter it). The sub form will display
the proper items. However, in my combo box, records matching only one
parameter will display, so the rest are blank. The combo box value don't
change based on the query parameter. What could be wrong?