Form trouble with Access 2000

  • Thread starter Thread starter Dan
  • Start date Start date
D

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
 
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
Click to expand...

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.
 
Back
Top