When I enter data into a form in a particular field, the data appears differently in the form than it does when I open the table that the form is linked to. Specifically, I have three combo boxes on the form that are linked to each other. The list of options for the second one is limited by the value chosen in the first and the list of options for the third combo box is similarly limited by the value chosen in the second. The problem occurs with the third one. I will choose one of the options in the shortened list for the third combo box and when I close the form and open the associated table, the value for the corresponding field in the same record will be different.
Additionally, I have noticed that the difference is not entirely random. The third combo box draws its values from a lookup table with fields corresponding to all three combo boxes. The records in the lookup table are sorted by the first field, corresponding to the first combo box (for the example, let's say they're letters A,B,C and D). Again for this example let's say that the third field contains numbers, three for each letter. Thus, if on the form, "B" is chosen in the first combo box, the third combo box will only show 4, 5 and 6. Now the pattern I have found is that the position of the number I choose from the third list in the form corresponds to the the position in the lookup table of the number that appears in the table linked to the form. So that if I choose "B" and "5" on the form, the table will show "B" and "2". The number "5" was second on the list in the combo box and when the records in the lookup table are sorted by letter, "2" is the second number on the list.
I hope I've been more descriptive and less confusing, but I fear I may have presented my problem the other way around.
Additionally, I have noticed that the difference is not entirely random. The third combo box draws its values from a lookup table with fields corresponding to all three combo boxes. The records in the lookup table are sorted by the first field, corresponding to the first combo box (for the example, let's say they're letters A,B,C and D). Again for this example let's say that the third field contains numbers, three for each letter. Thus, if on the form, "B" is chosen in the first combo box, the third combo box will only show 4, 5 and 6. Now the pattern I have found is that the position of the number I choose from the third list in the form corresponds to the the position in the lookup table of the number that appears in the table linked to the form. So that if I choose "B" and "5" on the form, the table will show "B" and "2". The number "5" was second on the list in the combo box and when the records in the lookup table are sorted by letter, "2" is the second number on the list.
I hope I've been more descriptive and less confusing, but I fear I may have presented my problem the other way around.
