Having to click twice to enter new record

Below is my code for a button to add new record.
it works but only after a second click and I don't know why. please help.

currentcontact is a global variable. It takes the value of contactid (CID) of the customer I wish to create new record for.
New record is created
I put currentcontact value inot contactid of new record
I call a function that sets states of certain fields
I call a procedure that pulls current VAT rate according to date

re: Having to click twice to enter new record

Have you tried to debug your code?

re: Having to click twice to enter new record

I did using msgboxs and debug.print but to no joy.

re: Having to click twice to enter new record

I'll assume for now you haven't read my last reply to you in your other thread, and have never noticed any of the edit comments I've been to the trouble of posting for you about using the [ CODE ] tags.

Next time though, I will have to issue you an infraction. The tags are not optional and must be used when posting code.

On to the subject at hand :
Fish posted a link behind the word debug. I suggest you visit the thread and allow it to teach you some very useful debugging techniques.

Let us know how you get on.