need to refresh subforms on unbound form
Posted on 2007-10-01
I have a refresh problem.
I have an unbound form that has 5 tab controls. Each tab page has a subform that is generated from a query and has detail information pertaining to the main prospect information. such as call detail, to-do's and so on. Each subform record has a button control that takes the user back to the correct record on the main form and that is where the information is entered for the detail. After the user enters the data and closes the main form, the to-do (unbound form) is still open, currently none of the 5 subforms requery the data unless the entire form is closed and reopened. Is there a way to requery if the tabs across the top are clicked on, or a better way for the subforms to requery without too much work for the user? I tried a requery button on the unbound form but that didn't affect any of the subforms if i use a requery button on the subforms it is on every record in the subform, and looks terrible, not to mention it doesn't work anyway!
Hope this is understandable if more info is needed, please let me know
any help would be a help