List Boxes

  • 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 amid the rest of the choices
from the list boxes.

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

MyTable
Field Name = Text
Display Control = List Box
Row Source Type = Value List
Row Source = "Name1";"Name2"
 
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 amid the rest of the choices
from the list boxes.

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

MyTable
Field Name = Text
Display Control = List Box
Row Source Type = Value List
Row Source = "Name1";"Name2"
Click to expand...

if it's a multi-select listbox then you need to set the Row Source
property in code because you cannot create a delimited list like that
in a query.

one of these articles should solve your problem:
http://www.mvps.org/access/reports/rpt0005.htm
http://www.mvps.org/access/forms/frm0007.htm
 
Back
Top