Query and List Box

G

Gary McQuigg

I've been given an Access Database with a table.

It appears someone tried to do a calculated field within the table
(redundant data and didn't work).

My quick? solution was to:

query the table,

replace the field with a calculation, in the query, that does work

print a report.



Problem with various list boxes.

I get a report with the selection highlighted and the rest of the choices
from the list boxs.

Is there anyway to return only the selected items, from the list box, in the
query?



MyTable

Field Name = Text

Display Control = List Box

Row Source Type = Value List

Row Source = "Name1";"Name2"
 
L

Lord Kelvan

this post would be better put in the formscoding group

microsoft.public.access.formscoding

you are more likly to get a responce there.

Regards
Kelvan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Unable to display values in 2nd list box from 1st list box selection 2
Drop down list control value in vba 2
Combo or list box 0
List Boxes 1
Creating a Search using a combo box and then creating a report. 4
list or combo box 0
query to show where no data in a stated column 0

Top