Form trouble with Access 2000

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

On Jun 16, 7:27*pm, Dan wrote:
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.

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

"Piet Linden" wrote:

On Jun 16, 7:27 pm, Dan wrote:
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.

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

My current Form:
http://img.photobucket.com/albums/v2...terDan/db1.jpg

The Error:
http://img.photobucket.com/albums/v2...terDan/db2.jpg

The duplicate field after:
http://img.photobucket.com/albums/v2...terDan/db3.jpg

The code I have.
http://img.photobucket.com/albums/v2...terDan/db4.jpg

Still need help!

"Dan" wrote:

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

"Piet Linden" wrote:

On Jun 16, 7:27 pm, Dan wrote:
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.