Form trouble with Access 2000

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
 
P

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cascading Drop Down boxes 1
Text Field is Now Combo Box 2
No text format selections 2
Unbound Data Entry Form 5
MS Access Sub form display with all entries 1
multi selection list fields 9
Help With MS Access 4
Access Access - Is it possible to repeat fields in a form? 1

Top