Hi,
The main form is based on a table.
I am using the following to open the form.
Case 4
If DCount("*", "QryFilter2") > 0 Then
DoCmd.Close acForm, "frmMenu"
DoCmd.OpenForm "frmSPAllDetails", acNormal, "qryFilter21"
DoCmd.Close acForm, "frmSPFilterOption"
Else...