Automatic Sort After Copying a record

[Silverblood]

I have a huge problem,
I have a form where there are companys with different contact-persons.
I sometimes need to add contact-persons for that company without typing adress and those kind of things, so i created a copy record button, But now i want the following:
If i copy a record (using the button) i want it to sort on [company] automaticly

Is this Possible, And if so Can some1 tell me hoe to do this

Kind Regards

SilverBlood

There's Nothing To Fear But Fear Itself

 

[Silverblood]

it doesn't work.. it says can't find macro me

 

[seth_belgium]

This is how you have to do it. Clear what you have typed in the AfterInsert property. Then double-click on it so it shows something like '[Programcode]'. Then push the button next to the field (right-hand) with the '...' on it.

Now you're in the VBA-editor and you'll see something like this:

Sub Field_AfterInsert()

End Sub

Between the Sub and the End Sub line, type Me.Requery

Save it all and try again. You may close the VBA-editor, it runs in the background of your database.

Good luck!

Greetz,

Seth