Listbox value to a Textbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Friends,

The purpose behind the question is some thing like this: I want to prepare a
report based on certain values of a table. So i designed a query with the
expected filed name with [Enter value]. But this takes only one value. I
entered the values like this : value1 or value2, but this brings up empty
result only. So i am trying like this:

I have a multi select Value list. The values are shown from a table. I want
to make a query by selecting some values from the list box. So in order to
collect the values, i want to select some items from the list box and show
them in the Textbox.

How can i do it.
 
I found that we could have as many as [Enter value], but this brings up so
many input boxes. Without knowing how many values we want to enter, how could
i limit the no of [enter value]?

Is there a better way to query multiple values for a table through Query
designer or Forms?

Pls help!

kesk
 
Hi Mr Alex,

I used the code as in http://www.mvps.org/access/reports/rpt0005.htm
and changed the controls as in my form. But i get a runtime error 2001, 'You
cancelled the previous Operation' is appearing.

I tried commenting the loqd.close, but still the same error.

Any more help will be appreciated.

kesk

Alex Dybenko said:
hi,
see http://www.mvps.org/access/reports/rpt0005.htm
and
http://www.mvps.org/access/forms/frm0007.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

kesk said:
Hi Friends,

The purpose behind the question is some thing like this: I want to prepare
a
report based on certain values of a table. So i designed a query with the
expected filed name with [Enter value]. But this takes only one value. I
entered the values like this : value1 or value2, but this brings up empty
result only. So i am trying like this:

I have a multi select Value list. The values are shown from a table. I
want
to make a query by selecting some values from the list box. So in order to
collect the values, i want to select some items from the list box and show
them in the Textbox.

How can i do it.
Click to expand...
Click to expand...
 
Back
Top