Search results

Use the BeforeUpdate event to qualify the changes.

FYI, the SetFocus is not necessary as Cancel = True will do this for you.

Use the BeforeUpdate event to enforce your validation. Cancel = True will hold the focus in the current control.

Welcome to AWF and enjoy.

Here's a link with code tag examples: https://access-programmers.co.uk/forums/showthread.php?t=240420

Highlight your code and then press the "#" sign in the tool bar.

Thanks for the update. :)

Yep. That's weird.

So adding the code tags allowed the trailing ""? "\"

Wow. It even stripped it out of that post.

The site will not let me post that trailing "". ???? I reported it to the Mods.

Follow Ridders directions. Hi Colin!

I ttried editing my post right away and it would not stick. change this line: MyVar = "C:\Folder1\Folder2" & CustomerID ...to... MyVar = "C:\Folder1\Folder2" & CustomerID

Try something like: Dim YourStringVar As String YourStringVar = C:\Folder1\Folder2" & CustomerID If Dir( YourStringVar ) <> "" Then Kill YourStringVar Warning: Untested

It should be under "Thread Tools" at the top of the thread. I believe it is only available to the OP of the thread and the Mods of course.

Did you want to mark this thread as Solved?

This probably runs pretty slow with all of those Domain functions. If the RowSource of the ComboBox is "tblDropROI" there is a much faster way to get the values. If "OrgID" is a number then your code should be: "[OrgID] = " & Me.OrgID )

Can you use the Format command? The output is always a String.

Welcome to the site Anne. Enjoy.

You do not need to user the Forms Collection. Just use: Aout = Me.Controls("A" & i)