Hey All,
I'm looking to click a button on a continuous subform that will select that record (ID) and then display (use subform.visible = true) and then hide the subform where I have just clicked the button, I'm ok with most of the code but I am having issues with finding a code that will allows me to select the record to show in the second subform.
Please can you give me a code I can use for this, I've been trying to make something like this work:
Ideally I'm thinking I would use something like:
Malcolm
I'm looking to click a button on a continuous subform that will select that record (ID) and then display (use subform.visible = true) and then hide the subform where I have just clicked the button, I'm ok with most of the code but I am having issues with finding a code that will allows me to select the record to show in the second subform.
Please can you give me a code I can use for this, I've been trying to make something like this work:
Code:
Docmd.gotocontrol (subform)
Docmd.gotorecord,,acNewRec
Ideally I'm thinking I would use something like:
Code:
DoCmd.GoToRecord,,Forms.[Mainform]![Subform]![ID]
Malcolm