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
|
|||
|
|||
Combo box not selecting correct field
Hi,
I have a combo box that contains this fields: INT-03 INT-11 INT-05 INT-16 INT-06A But when the user wants to select INT-11 the combo box displays INT-03 same thing with INT-16 combo box displays INT-06A. The combo box it just started doing this it was fine last week. Can anyone tell me what changed or a setting that I might have change without noticing? Thank you. |
#2
|
|||
|
|||
If the combo box just started doing this, I would suspect one of two things.
1) The combo box is corrupted, delete it and create a new one. 2) The index on the combo box's bound field is messed up (either in the Row Source table or the destination table). Try a Compact and Repair to redo the index. Just to clarify, you say that the combo box "contains this fields", are these possible values in the field or are you drawing data from multiple fields? -- Wayne Morgan MS Access MVP "GYO" wrote in message ... Hi, I have a combo box that contains this fields: INT-03 INT-11 INT-05 INT-16 INT-06A But when the user wants to select INT-11 the combo box displays INT-03 same thing with INT-16 combo box displays INT-06A. The combo box it just started doing this it was fine last week. Can anyone tell me what changed or a setting that I might have change without noticing? Thank you. |
#3
|
|||
|
|||
Hi, GYO.
Please post the RowSource, BoundColumn, ControlSource, and ColumnWidths properties of the combo box, and I'll be able to help you. Sprinks "GYO" wrote: Hi, I have a combo box that contains this fields: INT-03 INT-11 INT-05 INT-16 INT-06A But when the user wants to select INT-11 the combo box displays INT-03 same thing with INT-16 combo box displays INT-06A. The combo box it just started doing this it was fine last week. Can anyone tell me what changed or a setting that I might have change without noticing? Thank you. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Many-to-many implementation problem | Al Williams | Database Design | 15 | April 29th, 2005 05:19 PM |
Combo Box Problem | Mr. T | New Users | 15 | July 15th, 2004 09:47 PM |
NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |
Supress blank lines in DOCPROPERTY field | Mary | Formatting Long Documents | 10 | May 25th, 2004 07:27 PM |