LindaLooUK
Registered User.
- Local time
- Today, 16:17
- Joined
- Dec 30, 2014
- Messages
- 10
Hi everyone
I really hope you can help as I've spent way too long on trying to solve this issue myself. :banghead: I'll try and be brief.
FormA is making a call to FormC that is a subform of FormB. So, FormA is asking FormC to move to the next record and then provide the details of this next record to FormA. This works fine in as much as the correct details are displayed in FormA but FormC doesn't actually move to the next record!
In FormA I'm calling the (public) sub that's behind the NextRecord nav button on FormC (DoCmd.gotorecord,,acNext). If I then attempt to go to the previous record (from FormA) it fails because FormC still thinks it's on the first record and I obviously can't then go to a previous record.
This is the code in FormA:
Forms!frmB.frmC.SetFocus
Call Forms("frmB").Controls("frmC").Form.cmdNextCand_Click
How can I force FormC to actually move to (i.e. display) the next record when called from FormA?
I hope this makes sense!
I really hope you can help as I've spent way too long on trying to solve this issue myself. :banghead: I'll try and be brief.
FormA is making a call to FormC that is a subform of FormB. So, FormA is asking FormC to move to the next record and then provide the details of this next record to FormA. This works fine in as much as the correct details are displayed in FormA but FormC doesn't actually move to the next record!
In FormA I'm calling the (public) sub that's behind the NextRecord nav button on FormC (DoCmd.gotorecord,,acNext). If I then attempt to go to the previous record (from FormA) it fails because FormC still thinks it's on the first record and I obviously can't then go to a previous record.
This is the code in FormA:
Forms!frmB.frmC.SetFocus
Call Forms("frmB").Controls("frmC").Form.cmdNextCand_Click
How can I force FormC to actually move to (i.e. display) the next record when called from FormA?
I hope this makes sense!
Last edited: