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
|
|||
|
|||
Access2007 Combo Box
Never saw this before and can't fix. I have an unbound combo box with 6
names. In the form I can choose one name. When I look at the next record it has that name in it, the next and the next...How do I stop this? I want that name in the current record ONLY not all of 'em. I'm not a programmer so simple is good! Thank you Andrea |
#2
|
|||
|
|||
Access2007 Combo Box
On Thu, 3 Jun 2010 21:20:44 -0700, ALF wrote:
Never saw this before and can't fix. I have an unbound combo box with 6 names. In the form I can choose one name. When I look at the next record it has that name in it, the next and the next...How do I stop this? I want that name in the current record ONLY not all of 'em. I'm not a programmer so simple is good! Thank you Andrea An unbound combo box on a Continuous Form is *one combo box* - even if you see it six or sixty times on the form. If you want data to be associated with each record in a table, it must be *in the table (or in a related table). A combo box on a form is not a data storage medium. If you want the name to be in this record and not all of them - then the combo box MUST be bound to a field in the table. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Access2007 Combo Box
Because it is 'unbound' it does not reflect data from any record.
If you were to open the table you would see that the field does not contain data. -- Build a little, test a little. "ALF" wrote: Never saw this before and can't fix. I have an unbound combo box with 6 names. In the form I can choose one name. When I look at the next record it has that name in it, the next and the next...How do I stop this? I want that name in the current record ONLY not all of 'em. I'm not a programmer so simple is good! Thank you Andrea |
Thread Tools | |
Display Modes | |
|
|