Using Query For RecordSource 1

[fazm]

Can anyone give some insight to this:

I have a query:

SELECT a.ClientID, a.ClientFirstNm, a.ClientLastNm, b.EmployeeFirstNm, b.EmployeeLastNm, b.CaseLoadID
FROM tblClient AS a, tblEmployee AS b
WHERE a.CaseLoadID=b.CaseLoadID And ClientID=[Enter Client ID];

This is being used as the recordsource on a form via the properties window. Works great, but is there a way to have a msgbox pop up when the query dosent make a match in the database. The form just displays a blank form, no fields, just grayed out.

I have tried everything from capturing the contents of an input box, passing that value into my SQL string, and making the forms record source equal to the query in VBA, but have no luck.

The OnError only works with a valid run-time error and since this query doesnt cause a run-time error its a no go.

Any help or idea's would be great, thanks.

 

[CajunCenturion]

In the Form_Load event

If (Me.Recordset.RecordCount = 0) Then
MsgBox = "No Records"
' do whatever else you need to do.
End If


Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[fazm]

Thanks CajunCenturion for the quick response!!!

It worked perfect!!

I was making it to hard on myself!! Thanks again!

 

[CajunCenturion]

You're quite welcome.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein