open form to record in other opened form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've posted this here previously to some success but no resolution. I simply
need frmB.cbNavigateProfiles to open to the record in frmA.cbProfileID.

Anyone have any suggestions?

Thanks!
 
Pass the Profile ID value from frmA.cbProfileID in the OpenArgs parameter of
the OpenForm call:

DoCmd.OpenForm "frmB",,,,,,cbProfileID

Then in the Form_Load event of frmB, set the value of cbNavigateProfiles to
the passed value:

cbNavigateProfiles = Me.OpenArgs

Carl Rapson
 
Thanks, Carl. That's a fine solution however I open frmB with a button
located on frmA:

Private Sub cmdGOfrm_Click()
On Error GoTo Err_cmdGOfrm_Click

Dim stDocName As String

DoCmd.OpenForm Me!cbSelectForm, acNormal

Exit_cmdGOfrm_Click:
Exit Sub

Err_cmdGOfrm_Click:
MsgBox Err.Description
Resume Exit_cmdGOfrm_Click

End Sub

While your solution works well it defeats the purpose of how/why I currently
open frmB. Sorry for any confusion - I should've included this in my original
post.
 
Back
Top