[SOLVED] Refreshing only certain fields on a form after a subform has been updated
Hi all,
I've been attempting to modify the database that was originally posted here
Code is added so the main form refreshes after the reason box is changed after a date has been added, unfortunately when the main form refreshes it leaves the employee selected in the drop down box but the data in the subform refreshes to show employee 1's holiday data.
Is there a way to stop the subform data from changing or to set the refreshing code so only the data in the text boxes (Text35, Text37, Text61, Text65 & Text63) refresh?
A copy of the database is attached if someone can kindly have a look
Hi all,
I've been attempting to modify the database that was originally posted here
Code:
https://www.access-programmers.co.uk/forums/showthread.php?t=176891
Code is added so the main form refreshes after the reason box is changed after a date has been added, unfortunately when the main form refreshes it leaves the employee selected in the drop down box but the data in the subform refreshes to show employee 1's holiday data.
Is there a way to stop the subform data from changing or to set the refreshing code so only the data in the text boxes (Text35, Text37, Text61, Text65 & Text63) refresh?
A copy of the database is attached if someone can kindly have a look
Attachments
Last edited: