Is there a way to know which button opened a certain form?

[Soundhouse]

I have a single form that is opened via 2 different routes.

Button 1 opens the form with all records displayed

Button 2 opens the form with a filtered selection

This is all fine and dandy and is exactly what I want. However there are some controls on the form that I want to disable if the route I choose is Button 2.



Is there a way of identifying which button routed me to the form so that I can disable or keep enabled certain controls.

Hope this makes sense guys, any assistance would be much appreciated.

[Minty]

You can use the OpenArgs property of the DoCmd.OpenForm to pass in a string that could identify the button used.

Then in the form use If Me.OpenArgs = "String1" etc.

[Soundhouse]

Thank you for that tip Minty, that worked perfectly for what I needed.

Here's what I did for anyone else with a similar problem....

This is the code behind the source form button...

If Not IsNull(Me.TransUniqueID.Value) Then
'last argument of DoCmd uses OpenArg to pass Doc List button name for manipulation in target form
DoCmd.OpenForm "frmDocumentList", acNormal, "", "[TransUniqueID]='" & Me.TransUniqueID & "'", , , Me.cmdDocList.Name
End If

This is the code in the OnLoad event picking up the OpenArg property to allow me to hide certain controls dependent

'hide / display controls depending on where Doc List form is opened from
'if source OpenArgs property contains source button name, hide certain controls otherwise hide certain other controls if OpenArg is empty
If Not IsNull(Me.OpenArgs) Then
'hide controls if source button pressed from TransHdr form
Me.CmbDiscFill.Visible = False
Me.cmdFillDisc.Visible = False
Me.CmbRFIFill.Visible = False
Me.CmdFillRFI.Visible = False
Me.CmbTIREQFill.Visible = False
Me.CmdFillTIReq.Visible = False
Else 'hide controls if source button pressed from Tracker Main form
Me.Label34.Visible = False
Me.txtTransmittalID.Visible = False
End If