| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 107459 | 2010-02-16 21:21:00 | Access & bound form controls | Erayd (23) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 859254 | 2010-02-16 21:21:00 | I have an Access form with several free-text fields and a combo box. All of these controls are bound to the same query. The combo box gets its dropdown values by querying another table. Every field *except* the combo box can be changed - if I try to change the value in the combo box, it won't allow me to do so. How can I set the combo box to allow me to change its value, and have that value reflected in the database? Thanks, Erayd |
Erayd (23) | ||
| 859255 | 2010-02-16 23:21:00 | Look up 'Not in list' event, in help. | donread (6401) | ||
| 859256 | 2010-02-17 00:06:00 | Look up 'Not in list' event, in help. Hi Donread - thanks for taking the time to help :). Unfortunately, this isn't what I'm after. I'm not wanting to add new entries to the combo box - I just want to be able to select a different value off the list. At present, it seems to be stuck on whatever item it's currently on, and while I can see all the other options, I can't choose any of them. |
Erayd (23) | ||
| 859257 | 2010-02-17 06:15:00 | Well, that sounds like the 'On, or is it After update event' or simply therecord scource. I would re make the Combo Box, using the Wizard. Have look at some of the ready made Dbs or templates, that are offered by Access when choose New Access Data base in Office, there is bound to be a Combo doing simmilar to your intention. |
donread (6401) | ||
| 859258 | 2010-02-17 06:21:00 | to add to previous. Try http://www.rogersaccesslibrary.com/ If you are using Access, one of the best things you'll ever do, is join this group. ACCESS-L@PEACH.EASE.LSOFT.COM |
donread (6401) | ||
| 859259 | 2010-02-17 19:27:00 | Well, that sounds like the 'On, or is it After update event' or simply therecord scource.The 'control source' is the one I care about. There's no event handler attached to this combo box - it's a bound control - why would it need an event handler? I would re make the Combo Box, using the Wizard.Tried that, no joy - the wizard basically just did what I'd done manually the first time around anyway. Have look at some of the ready made Dbs or templates, that are offered by Access when choose New Access Data base in Office, there is bound to be a Combo doing simmilar to your intention.Tried that, and couldn't find one - was there a particular example you had in mind? to add to previous. Try www.rogersaccesslibrary.com there a particular example you think I should look at? Judging by the titles, none of them seem to be applicable. |
Erayd (23) | ||
| 859260 | 2010-02-17 20:41:00 | Never mind - solved it. Turned out my problem wasn't related to the combo box at all - one of my SELECT statements was accidentally getting a field from the wrong table (and that field is immutable), however as it had the same name I didn't notice. As a result, I couldn't change the field using the combo box. Donread - thanks for your help :). |
Erayd (23) | ||
| 859261 | 2010-02-17 21:09:00 | Good I repeat though, If you are using Access, one of the best things you'll ever do, is join this group. ACCESS-L@PEACH.EASE.LSOFT.COM Most helpfull, Learner to Expert |
donread (6401) | ||
| 859262 | 2010-02-17 22:04:00 | Good to know - thanks :thumbs:. | Erayd (23) | ||
| 1 | |||||