Hi there,
I have two versions of a database going right now. One of them is a live version and the other is a development version. I am making changes to the development version and then importing the forms with the changes made into the live version.
I've run into a strange phenomenon. I sort the list and combo boxes of those forms in the development version by a particular variable but when I import those same forms into the live version (and overwrite the originals) it doesn't sort them. However, if I open up the imported form in design mode and then just click and move the the list/combo box a pixel in any direction, then close the design view without saving and then look at the form again it magically sorts everything correctly even though I didn't save any changes.
I think this all has something to do with a cache or refreshing issue but I can't be sure and I haven't been able to find links about it anywhere else. Has anyone here experienced this before? Do you remember what you did to fix it so that the list/combo boxes are correct when you import them without having to click on those boxes in design mode?
I have two versions of a database going right now. One of them is a live version and the other is a development version. I am making changes to the development version and then importing the forms with the changes made into the live version.
I've run into a strange phenomenon. I sort the list and combo boxes of those forms in the development version by a particular variable but when I import those same forms into the live version (and overwrite the originals) it doesn't sort them. However, if I open up the imported form in design mode and then just click and move the the list/combo box a pixel in any direction, then close the design view without saving and then look at the form again it magically sorts everything correctly even though I didn't save any changes.
I think this all has something to do with a cache or refreshing issue but I can't be sure and I haven't been able to find links about it anywhere else. Has anyone here experienced this before? Do you remember what you did to fix it so that the list/combo boxes are correct when you import them without having to click on those boxes in design mode?
Last edited: