if event Frm.Current is not triggered when recordset is empty,which one should I use?

[Ricardo de Mila]

I'm not sure, but I think that the form.current event does not occour if the recordset is changed and coincidently it does not contain any data.
Is there any event that occour everytime the recordset is changed in a form even if the new recordset is empty?

Best regards
Ricardo

[zmbd]

Just to clarify what you are asking, when you say, the recordset is changed on a form, do you mean:

form.RecordSource = "Query1"
>>>changes to >>> form.RecordSource = "Query_02"

The normal order of events for a form and subforms is:
Open>Load>Resize>Activate>((GotFocus))>Current
(the gotfocus event depends on if there are controls on the form or not)
Here's a link to the general order of events:
Microsoft>Office>Order of events for database objects

If you will provide an example of your script (properly formatted with the [CODE/] tool :) ) along with a clear explanation of what you want along with what it's not doing we might be able to provide you with a clearer answer.

[NeoPa]

Ricardo de Milano:
I'm not sure, but I think that the form.current event does not occour if the recordset is changed and coincidently it does not contain any data.

Please determine the answer to that part yourself. This should be done before posting the question. This is basic.

Ricardo de Milano:
Is there any event that occour everytime the recordset is changed in a form even if the new recordset is empty?

IE. Which event can be used to gain control when .Recordset is changed for a Form object, regardless of whether or not any records are returned?