Query and List Box

  • Thread starter Thread starter Gary McQuigg
  • Start date Start date
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"
 
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
 
Back
Top