Selecting a list box item for update

Hello all,

I have a list box on my main form (lstBorrowerLoans) which should the books a borrower has on loan, due date, return date etc.

In some cases, a borrower may haver several books out due at differeng days.

I have another form called frmCheckIn which allows me to update the fields in the list box.

Problem:

The frmCheckIn only updates the first item in the list of items shown in the list box. How can i double click on say the second or fourth borrowed item in the list box and modify its value using frmCheckin?

Many thanks in advance
--
Carlee

Hi Carlee,
It sounds as if the field being used to link the list
box item is not unique to the record, and, therefore, the
process is selecting the first instance of the field it
finds. E.g.: Jones has BookA and Jones has BookB. If the
borrower name is the link, then the process searches until
it finds the first instance of Jones and offers that up
for update.
If there is another field in the record that is unique
to each borrowed book record (e.g. transaction ID,
autonumber, etc.), add that to the list and use it as the
selection key.
If there is no such field, then you might have to try
concatenating two fields from each record to fabricate
a "unique" field for the record that could be used as the
link (e.g.: borrower&title would create JonesBookA and
JonesBookB).

Hope this helps.

-----Original Message-----
Hello all,

I have a list box on my main form (lstBorrowerLoans)
which should the books a borrower has on loan, due date,
return date etc.

In some cases, a borrower may haver several books out due
at differeng days.

I have another form called frmCheckIn which allows me to
update the fields in the list box.

Problem:

The frmCheckIn only updates the first item in the list of
items shown in the list box. How can i double click on
say the second or fourth borrowed item in the list box and
modify its value using frmCheckin?

Many thanks in advance
--
Carlee
.