open form to record in other opened form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnLute - 15 Mar 2007 15:19 GMT

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!

Signature

www.Marzetti.com

Reply to this Message

Carl Rapson - 15 Mar 2007 17:10 GMT

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

> I've posted this here previously to some success but no resolution. I
> simply
[quoted text clipped - 3 lines]
>
> Thanks!

Reply to this Message

JohnLute - 15 Mar 2007 17:27 GMT

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.

Signature

www.Marzetti.com

> Pass the Profile ID value from frmA.cbProfileID in the OpenArgs parameter of
> the OpenForm call:
[quoted text clipped - 15 lines]
> >
> > Thanks!

Reply to this Message