I have a form with several other forms embedded in it. In one of the particular sub-forms i wanted to have one text box where you type in a number and another textbox that displays an automatic description corresponding to this number.
The sub form works fine on it's own - i set a condition that when the textbox with the number in it is changed, the form is refreshed.
However, this causes display problems when scrolling through the main form. If i scroll down the form, then change the record (which changes the data shown in the refreshing box) the main form redisplays on top of itself creating a mess onscreen.
I thought about using a combo-box to select the number i wanted rather than have it refresh, but i have problems with this as well as the number and description appear in different tables and are linked by a relationship.
If there is no way round this i'll have to try to have the form so it fits on one page, so no scrolling is required.
Cheers,
Ben
The sub form works fine on it's own - i set a condition that when the textbox with the number in it is changed, the form is refreshed.
However, this causes display problems when scrolling through the main form. If i scroll down the form, then change the record (which changes the data shown in the refreshing box) the main form redisplays on top of itself creating a mess onscreen.
I thought about using a combo-box to select the number i wanted rather than have it refresh, but i have problems with this as well as the number and description appear in different tables and are linked by a relationship.
If there is no way round this i'll have to try to have the form so it fits on one page, so no scrolling is required.
Cheers,
Ben
