List Box Question

[Chad]

I have a query that returns all fields from a particular
table where field1 is Like Forms!frmForm1!txtText1. I want
to display these values in a list box but whenever I try
to use the iwzard to do this, I get an error message
saying "No value given for one or more required
parameters" and it wont let me complete the list box
wizard. Can someone please let me know why this is
happening and how I can avoid it?


Thanks,
Chad

 

[Dirk Goldgar]

I have a query that returns all fields from a particular
table where field1 is Like Forms!frmForm1!txtText1. I want
to display these values in a list box but whenever I try
to use the iwzard to do this, I get an error message
saying "No value given for one or more required
parameters" and it wont let me complete the list box
wizard. Can someone please let me know why this is
happening and how I can avoid it?

Is form "frmForm1" is open at the time you run the wizard? If not, try
it that way. The wizard needs to be able to open the query in order to
build a field list to display.

If it doesn't work with the form open, temporarily remove the criterion
from the query and save it. Then use the wizard. After the list box
has been built, restore the query's criterion.