J
JB_96RS
I have a sub form that displays the results of a query once a number
from a list box is picked. When I run the query from outside of the
form all goes as planned. But, when I run it from the form nothing
shows up. The query the results are based on consisted of one table
and two fields from that table. I am trying to add another table to it
and display a field from the new table in the sub form with the rest of
the results. Before I added the new table to the query all worked fine
in the subform. And I have setup the text boxes in the subform for the
new field. Any ideas?
Thanks,
JB
from a list box is picked. When I run the query from outside of the
form all goes as planned. But, when I run it from the form nothing
shows up. The query the results are based on consisted of one table
and two fields from that table. I am trying to add another table to it
and display a field from the new table in the sub form with the rest of
the results. Before I added the new table to the query all worked fine
in the subform. And I have setup the text boxes in the subform for the
new field. Any ideas?
Thanks,
JB