Yes, those are breakpoints. Now run code.
Yes, those are breakpoints. Now run code.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
It's saying that the value of txtAlternateB is "", so I guess technically it's not null?
So, intuitively I tried:
And it worked hehe I have a couple more things I'd like to ask about that are unrelated to the title of this post, but are still based on the functionality of this same project. Should I make a new thread?Code:If Not (Me.txtAlternateA = "") Then CurrentDb.Execute "INSERT INTO EntryFormTable(Component, Description, UOM) " & _ " VALUES ('" & Me.txtAlternateA & "','" & Me.txtAltADescription & " \ALT" & "','" & Me.txtAltAUOM & "')" End If If Not (Me.txtAlternateB = "") Then CurrentDb.Execute "INSERT INTO EntryFormTable(Component, Description, UOM) " & _ " VALUES ('" & Me.txtAlternateB & "','" & Me.txtAltBDescription & " \ALT" & "','" & Me.txtAltBUOM & "')" End If
New thread sounds like good idea. Can reference link to this thread if think relevant.
I never allow empty strings in fields.
The following handles both Null and empty string.
If Not Me.txtAlternateB & "" = "" Then
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Excellent. I will use that.