Recordset of my form...

[griswom]

Hello all,

I have a form that uses a parameter query to build the recordset for the form. After the parameter is entered, I would like to be able to test to see if the query returns any records. If so...load form, if not...close form. How can this be accomplished? Any advice would be appreciated. Thanks,

Griz

 

[LonnieJohnson]

Try this as the form's On Load event...


Private Sub Form_Load()

If Me.RecordsetClone.RecordCount = 0 Then

MsgBox "No records to display.", vbInformation
DoCmd.Close acForm, "YourFormNameHere"

End If

End Sub

Hope this helps...

prodevmg@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

May God bless you in the year 2002.

 

[FoxProProgrammer]

You can use the RecordCount property of a recordset to see if any records were returned. If the name of your recordset is rs, this would work:

If rs.RecordCount > 0
DoCmd.OpenForm...
Else
DoCmd.Close
End If

dz

 

[nabiS2K]

You can use the form's recordsetclone. With an IF statment...

If Me.RecordSetClone.RecordCount = 0 Then
     DoCmd.Close acForm, Me.Name
End If

Just paste this into the Form's OnOpen event.
God Bless
Mike ;-)

 

[nabiS2K]

Apparently we must have all been typing at the same time. LOL God Bless
Mike ;-)

 

[FoxProProgrammer]

Yes, Mike. lol I hate when that happens because somebody might think that you are infringing on their territory! )

Best,

dz

 

[griswom]

Hello All,

Thank you for all of the quick and accurate responses. I implemented this into my form and it works beautifully. I appreciate your time and efforts.

Griz