Filter problem

[peterbowles]

I am calling a filter dlg form a form where i select a the criterion. If there are no recods that match the criteria then form goes blank

how do i say

if there are records that match the criteria then don't filter

 

[Mile-O]

I am calling a filter dlg form a form where i select a the criterion.

Can you rewrite that part please?

 

[peterbowles]

Re: Re: Filter problem

sorry My non expert typing skills again.

I have a form called Employees. From that form I call another form called (dlg Filter Employees) on the form (dlg Filter Employees) I can select certain filters i.e. Name, Type, Year started. When I press ok on this form (dlg Filter Employees.The form Emplyees is then updated with the applied filter

 

[Mile-O]

When the second form opens you can use it's OnOpen() event to test its RecordSource.

I can't remember the exact syntax offhand but it may be something like:

If Me.RecordsetClone.RecordCount = 0 Then Cancel = True