Problem: Runtime Error 9

Hi,

I've been having a hard time figuring out how to resolve this error message. I have created the form attached and it is working 100% on my end.

However, my colleagues keeps getting this Runtime Error 9 and I cant seem to replicate the issue as it directs them to the below string:

Please Login or Register  to view this content.

Is there a way to eliminate that "Engine" file and have a direct code that functions the same? I somewhat learned that code in a YouTube tutorial and it functions as either when there is a "New" entry or when I am doing a "Edit" entry. I used for adding entries and when I go and modify an entry as reference.

I hope there is somewhat a workaround on this one.

Thanks

You could just replace Sheets("Engine") with Sheet3 in each case.

That's not what I said. I said replace Sheets("Engine") with Sheet3 - i.e.

Please Login or Register  to view this content.

or preferably:

Please Login or Register  to view this content.

Why do you want a random number for that? Why not just add 1 to the highest previous number?

You'd have to check whether you happened to have already used that generated number, so if you can use a unique prefix, you could simply check for the highest number used with that prefix and then add 1 to it. This should really be a different thread though as it has nothing to do with the original question.