Need Help To Finish Creating ListBox...PLEASE

[Summer]

Hi,

(Hope I am providing the necessary information, please ask if I haven't)

I have been cramming for a week reading the Access Help files, newsgroups,
websites, etc., and practicing on a non-production Household Inventory
database application. Using Access 2003. The db application is an Access
2000 version d/l'd from MSoft.

ALL I want to do is get this one list box (I created) on an existing form to
display more than one item selected from a table (I created) so I do not
have to type the same multiple items over and over on each inventory record.
I have over a thousand records to key-in.

Here's what I did: Created a Table using the wizard:

(PK)Receipts/RecordsID datatype Autonumber
ReceiptsType datatype Text

It has these seven items (values?):

Original Receipt
Cancelled Check
Owner's Manual
Repair Record
Credit Card Receipt
Credit Card Statement
Videotape

List box properties are:

Name Receipts/RecordsID
Control Source Receipts/RecordsID
Row Source Type Table/Query
Row Source Receipts/Records
....
Column Count 2
Column Widths 0";2"
Bound Column 1
....
Multi Select Extended
....
(I set up no [Event Procedures]. Maybe that's the problem.)

Following the example of the two existing tables, Catagories and Rooms
(relationship of one-to-many and join type 3), I joined my Receipts/Records
table to the main Household Inventory table by dragging the PK
(Receipts/RecordsID) over to the identically named (Receipts/RecordsID).

At first, the field on the form *appeared* to work. That is, I can see all
seven items from the table if I click on the scrollbar (the field is
currently set as one row in height). It will even highlight, in black, each
item when I select it using CTRL-click. This is not what I had in mind at
all. The field does not display each selected item separately on one row. I
want to select each item that applies, from a list, and have it display on
the form like this:

(label) (list)
Receipts/Records Credit Card Statement, Original Receipt,
Repair Record

I looked for an example in the NorthWind Sample. Found none. Can someone
*please* help me with this? I intend to learn Access at a deeper level but
do not have the time to do it now. I have to get on with the home inventory
data-entry and cannot waste any more time trying to figure this out. I
thought I was heading in the right direction, making great progress, right
up to the very end. Then slam!, hit a brick wall. Now I'm not so sure... )

Any insight you can provide will be appreciated.

 

[Summer]

Okay, I just spotted in another post what may be the answer to my problem:

[Subject: Choosing more than one item in a list: "You can't (without some
code) and shouldn't store multiple values in a single field. The values
should be stored in a related table where each "selection" would create its
own record."-- Duane Hookom MS Access MVP]

--
Summer

SNIP

ALL I want to do is get this one list box (I created) on an existing form
to
display more than one item selected from a table (I created) so I do not
have to type the same multiple items over and over on each inventory
record.
I have over a thousand records to key-in.

SNIP

 

[Summer]

Well, problem is finally solved! ) I changed the list box to a combo box,
tweaked that, tracked down and edited Receipts/Records to the more
code-friendly ReceiptsRecords (oh, boy was it fun trying to eliminate all
the error messages!), added two Event Procedures via copy/paste (this was
the easiest part) and even added Enter/View ReceiptsRecords to the Forms
Switchboard (even easier). I think I have found a new hobby. )

Thank You Duane Hookom for your "indirect" help!