Preventing that de vba interface shows up. Plus avoid invalid data to be entered in a text box.

[Anacronos]

I have a field that is generated by
Me.Id = Format(Date, "YYYYMMDD") & "-" & Me.TxtId_dia
So each day I can put one "1" and there´s no problem. The deal is that when someone enters in the same day another "1" (I know it´s logical) a error message kicks in but the thing is I would like to write that text box by myself cuz that the default msgbox that shows up has a button that opens the interface of VBA so I don´t want my users to see that. I have no clue about how to do that there´s no On error event on the text box.

[ssanfu]

It sounds like "Me.ID" ("ID" is a poor name) is the primary key of a table. If YOU enter a 1 for today and the value generated is "20160225-1" AND someone else later tries to enter a 1, you would have duplicate primary key values.
Having duplicate primary key values is not allowed - so you get an error.
If you don't want the debug error dialog box to be displayed, you need to add error handling to the routine or use custom autonumbers.

Custom autonumbers (aka roll you own) would alleviate this problem.
Something like http://baldyweb.com/CustomAutonumber.htm

[Anacronos]

How can I add some error handling, since the event "On Error" does not apply to the text box?
I´m not worried about the custom autonumber, and there´s another thing about it. They´re not always added sequentially.

[ssanfu]

default msgbox that shows up has a button that opens the interface of VBA

The error handler should be in the VBA code. Or maybe I'm misunderstanding your problem.

[Anacronos]

No, I think you get it xD I´m having trouble describing the problem xD. I want two things prevent that the user adds a number that has already been added that day and it will also prevent that that error message shows up.

[Anacronos]

Fellow, I kind of solve it. I used the Dcount metod https://msdn.microsoft.com/en-us/lib...ffice.11).aspx
So I counted the Id_dia already saved with the criteria being the date so It will only count those ones from the same day.
Then with a If compared if it was more than >0. Thank you :3

[ssanfu]

Glad you worked it out.