Hi Folks. Should be simple enough, but I'm going cross-eyed researching this:
I've got a main form that displays records of individuals (selected from a combo box) Part of the data requires that I store 'from' and 'to' dates and as I need to keep a history as new periods are entered, I am using a sub form.
So far-so good. Thing is, I need several of these subforms and in order to de-clutter the form have hidden them and show them via a button. What I want to do is show only the most recent 'to' date in a textbox on the main form so that the user can decide whether to update the subform.
Your assistance would be most gratefully appreciated.
Chalkie.
I've got a main form that displays records of individuals (selected from a combo box) Part of the data requires that I store 'from' and 'to' dates and as I need to keep a history as new periods are entered, I am using a sub form.
So far-so good. Thing is, I need several of these subforms and in order to de-clutter the form have hidden them and show them via a button. What I want to do is show only the most recent 'to' date in a textbox on the main form so that the user can decide whether to update the subform.
Your assistance would be most gratefully appreciated.
Chalkie.