chrisjames25
Registered User.
- Local time
- Today, 23:04
- Joined
- Dec 1, 2014
- Messages
- 401
Hi
I have a form with a subform embedded. WIthin the subform there is a cmd button that when clicked opens another form.
The other form that is opened allows me to edit the names of data in the subform. When i click amend in the pop out edit form the name in the subform of form 1 changes as you would expect.
WHat doesnt occur is the subform in form 1has a sort criteria of ascending and if i changed a name from Adam to William it still appears at top of my subform until i add a new name in form 1 and then the form requeries.
So i am basically asking how do i requery my subform from another form after making the edit. I would like this requery to occur just before i docmd.close on form2
Thank you in advance
I have a form with a subform embedded. WIthin the subform there is a cmd button that when clicked opens another form.
The other form that is opened allows me to edit the names of data in the subform. When i click amend in the pop out edit form the name in the subform of form 1 changes as you would expect.
WHat doesnt occur is the subform in form 1has a sort criteria of ascending and if i changed a name from Adam to William it still appears at top of my subform until i add a new name in form 1 and then the form requeries.
So i am basically asking how do i requery my subform from another form after making the edit. I would like this requery to occur just before i docmd.close on form2
Thank you in advance