If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Form trouble with Access 2000
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. |
#3
|
|||
|
|||
Form trouble with Access 2000
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. |
#4
|
|||
|
|||
Form trouble with Access 2000
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. |
Thread Tools | |
Display Modes | |
|
|