Updating tables based on Items in a Listbox

[drjmwebb]

I am using Access 2000/Windows 2000 on a Novel network

I have a multi-user program that tracks documents and their holders.
There are three primary tables tblHolders, tblDocuments and a link
table tblDoc_Holders.

The program is complete other than a way to assign new documents to a
holder.
I am stuck on how best to accomplish this. I currently have a form
with two listboxes, lstSource (multi-select) is populated using a
predefined query of active documents in tblDocuments and lstAssigned
(multi-select)has a .RowSourceType of "Value List" and .RowSource =
"". Item(s) selected in lstSource have their Doc_ID and Doc_Title
added to a ";" delimited list in the RowSource of lstAssigned (the
document is not removed from lstSource when added to lstAssigned
becaues a holder can have multiple copies of the same document).

Here then lies my issues:

1) Limitation on the size of the lstAssigned.RowSource (2048 chr ?) I
know it is a lot but in testing this has been an issue.

2) Before writting to the link table each record will be assigned the
Holder _ID and a doc_Traking_Number based on the next available number
for that document. This number is stored as a field in tblDocument and
gets increased as a document gets assigned. I do not want to increase
the number in tblDocument until the user commits to the change and
need to prevent duplication of numbers if multiple users are assigning
the same document to diffrent people at the same time.

I have spent a lot of time researching this, and while there is lots
of information on working with lists boxes I can not find one that
covers these issues. I am starting to investigate the use of
recordsets but am unsure if this is a wise choice. Any help would be
much appriciated.