Posted on 2016-10-20
I have a form: frmDraws
I have a button on this frm that takes me to an OPTION form: frmRateOptions
then from this form I choose to open another form.
I think I lose the OpenArgs, correct because I am opening another form?
How can I temporarily "save" the OpenArgs?
Private Sub cmdRates_Click()
DoCmd.OpenForm "frmRatesChoose", , , , , , OpenArgs:=Me.ID
frmRatesChoose (UNBOUND FORM):
I click the button for the option I want and the form opens with the following ON LOAD:
Private Sub Form_Load()
If Nz(Me.OpenArgs, "") <> "" Then
Me.Filter = "[DrawID] = " & Me.OpenArgs 'I lose the open args.
Me.FilterOn = True
Let me know if you need additional information.
thank you fo rthe help