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
Thanks,
JB