B
Brad Pears
I have a parent form which includes two subforms - each of which contain
combo boxes (among other things) ... where the user can select various items
related to the master form. These combo boxes contain a code "description".
i.e. The combo box actually shows the description of a numeric code --
which is stored in an underlying table. So, for instance, the code might be
a 05, but the description of the code might read "This is a test". This
description is what is actually displayed in the combo box... not the '05'.
The description for this code of 05, is stored in a master code table. So
what happens is the master table actually has a code field which contains
the value of the code -0 not the description. When a record is displayed on
teh form, the combo box displays the descrioption for this code from the
codes table.
I have another form the user can call up which allows them to maintain
codes. it allwos them to change description, add codes - even change one
code number to another if they wanted to keep them in some sort of sequence.
If the user happens to change the code 05 for exacmple - to a code value of
09, I use referential integrity to change the code 05 to 09 in every record
in the master... This happens no probs, but when the user exits the code
maintenance form (a pop-up form) and goes back to the master form, if that
record happened to have been displaying the code the user changed, the
description is now not showing in the combo box. I tried to refresh the
combo box directly and I also did a requery directly on the combo box after
the referential integrity code runs, but still nothing. The user has to move
off of that record and back again before the description shows up...
Is this something they will jsut have to put up with or is there something
that can be done to clean this up??
Thanks,
Brad
combo boxes (among other things) ... where the user can select various items
related to the master form. These combo boxes contain a code "description".
i.e. The combo box actually shows the description of a numeric code --
which is stored in an underlying table. So, for instance, the code might be
a 05, but the description of the code might read "This is a test". This
description is what is actually displayed in the combo box... not the '05'.
The description for this code of 05, is stored in a master code table. So
what happens is the master table actually has a code field which contains
the value of the code -0 not the description. When a record is displayed on
teh form, the combo box displays the descrioption for this code from the
codes table.
I have another form the user can call up which allows them to maintain
codes. it allwos them to change description, add codes - even change one
code number to another if they wanted to keep them in some sort of sequence.
If the user happens to change the code 05 for exacmple - to a code value of
09, I use referential integrity to change the code 05 to 09 in every record
in the master... This happens no probs, but when the user exits the code
maintenance form (a pop-up form) and goes back to the master form, if that
record happened to have been displaying the code the user changed, the
description is now not showing in the combo box. I tried to refresh the
combo box directly and I also did a requery directly on the combo box after
the referential integrity code runs, but still nothing. The user has to move
off of that record and back again before the description shows up...
Is this something they will jsut have to put up with or is there something
that can be done to clean this up??
Thanks,
Brad