Creating an error message

[cdawley4]

Hi,

I am working on a database with lots of projects for work. One of the fields I added was a Start Time. I made this an Indexed field (Yes, No Duplicates). Is there a way for me to create a message box in vb that will prompt the user that the time specified is already used on another project? The start time err message in vb code is referenced by Command19_Click, if that helps.

 

[lupins46]

?Why can't two projects start at the same time?

 

[cdawley4]

We only have one phone number to work with and if you get a lot of people doing different projects at the same time, everyone gets confused.