If and Else - very simple question

[tygereye]

Oops, sorry - it's Creativity

[RuralGuy]

That is weird. All I did was rename that TextBox without the embedded space in the name. Now it seems to work as one would expect.

[trevor40]

This won't work.

MsgBox "This batch number [" & Me.Batch_Number & "] has already been logged!" & vbCrLf & _
"For Re-Assays, add suffix RE1 or RE2, as necessary.", vbOKOnly, "Duplicated entry"

Try this in stead
MsgBox "This batch number " & Me.Batch_Number & " has already been logged!" & vbCrLf & _
"For Re-Assays, add suffix RE1 or RE2, as necessary.", vbOKOnly, "Duplicated entry"

[RuralGuy]

This won't work.

MsgBox "This batch number [" & Me.Batch_Number & "] has already been logged!" & vbCrLf & _
"For Re-Assays, add suffix RE1 or RE2, as necessary.", vbOKOnly, "Duplicated entry"

Try this in stead
MsgBox "This batch number " & Me.Batch_Number & " has already been logged!" & vbCrLf & _
"For Re-Assays, add suffix RE1 or RE2, as necessary.", vbOKOnly, "Duplicated entry"

What do you mean by "This won't work?" Why?

[trevor40]

I'm sure I allready posted this but I'll try again, It could be confusing if you don't read this carefully, I know the brackets are inside the comments but it does look a bit odd like that.

MsgBox "This batch number [" & Me.Batch_Number & "] has already been logged!" & vbCrLf & _
"For Re-Assays, add suffix RE1 or RE2, as necessary.", vbOKOnly, "Duplicated entry"

MsgBox "This batch number " & Me.Batch_Number & " has already been logged!" & vbCrLf & _
"For Re-Assays, add suffix RE1 or RE2, as necessary.", vbOKOnly, "Duplicated entry"

[tygereye]

Hi again
I have changed the TextBox to not having the embedded space.
Still no luck.
Then I noticed you had Data Entry set to 'No' under Properties. I did the same and then it worked!
However, eventually I need the operators to see the blank form upon opening. Any suggestions?

[RuralGuy]

I forgot I did that. Data Entry keeps the Recordset from seeing anything but new records. Use the OnLoad event of the form to move to a new record.

[tygereye]

RuralGuy, it is working!
Thank you SOOO much!
I really appreciate it.
Have a great day!

[RuralGuy]

That's great! Glad we could help.