In my database, I have a public declaration which defines a location or place. This is normally restricted to one location and there is not often the need to change the location onse it is set. However, being only human, users might mispell their location and need to change it. I use this location for headings on reports and on some forms.
I want to be able to refresh the public declaration once the form used to change the location is closed, hence updating other forms that are open.
Does anyone have any ideas? I've tried a few different situations but seem to be going around in circles.
I want to be able to refresh the public declaration once the form used to change the location is closed, hence updating other forms that are open.
Does anyone have any ideas? I've tried a few different situations but seem to be going around in circles.
