How to Open a Form in "Filter by Form" grid

[chris3942]

When choosing "Filter by Form" you are presented with a blank form (ala "grid&quot into which you can enter "search specs". I would like to open a form, have it automatically enter a "Filter by Form" mode with a 'cleared grid' ready for the user to input the "search specs". Any help will be appreciated.

 

[danvlas]

Private Sub Form_Load()
DoCmd.RunCommand acCmdFilterByForm
End Sub


Good luck



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[chris3942]

Hi Dan,

Thanks for your help.Here's the "On Click" [Event Procedure] code I use to open the "SEW-UP PARTS" form:


Private Sub CB_Open_Sew_Up_Parts_Form_Click()
On Error GoTo Err_CB_Open_Sew_Up_Parts_Form_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "SEW-UP PARTS"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_CB_Open_Sew_Up_Parts_Form_Click:
Exit Sub

Err_CB_Open_Sew_Up_Parts_Form_Click:
MsgBox Err.Description
Resume Exit_CB_Open_Sew_Up_Parts_Form_Click

End Sub



Your reply to my help request on opening the form with a blank grid of a "Filter by Form" was:

Private Sub Form_Load()
DoCmd.RunCommand acCmdFilterByForm
End Sub



How do I incorporate your code into mine?

Chris

 

[danvlas]

Open the form in Design View
Go to View-Properties
Find 'On Load'
Type [Event Procedure]
Click the 3 little dots.
Paste the line:
DoCmd.RunCommand acCmdFilterByForm
Open the form.


Good luck



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html