Form trouble with Access 2000

[Dan]

Hello there!

I'm having an issue with access 2000. I'm trying to make one form where I
can select from different tables from list boxes, and then have my selections
go to another table. I have it so the form shows the selections from each
list, but when I click on a selection I get an error that says "Cannot update
field text" and breaks. It then adds another duplicate entry to that field. I
would like it to just select from the lists by what I click on, and have it
sent to another table. Any suggestions?

-Dan

 

[Piet Linden]

Hello there!

I'm having an issue with access 2000. I'm trying to make one form where I
can select from different tables from list boxes, and then have my selections
go to another table. I have it so the form shows the selections from each
list, but when I click on a selection I get an error that says "Cannot update
field text" and breaks. It then adds another duplicate entry to that field. I
would like it to just select from the lists by what I click on, and have it
sent to another table. Any suggestions?

-Dan

Why listboxes? The only time I ever use listboxes for anything is
when I want to be able to select multiple items at once (but then the
selections have to be handled programmatically, because you cannot
bind a multi-select listbox to a column in a table). Save yourself
the trouble and use comboboxes instead.

 

[Dan]

I re-did it using combo boxes and still got the same error.

 

[Dan]

I've taken some screenshots, maybe you can see something I can't.

My current Form:
http://img.photobucket.com/albums/v282/MasterDan/db1.jpg

The Error:
http://img.photobucket.com/albums/v282/MasterDan/db2.jpg

The duplicate field after:
http://img.photobucket.com/albums/v282/MasterDan/db3.jpg

The code I have.
http://img.photobucket.com/albums/v282/MasterDan/db4.jpg

Still need help!