If, Then, ElseIf?

[Samantha]

TM Rate is a currency field would that have an effect?

 

[Samantha]

Ahh, IT WORKS! Thank you so much for the help, I think the Option Explicit may have been the initial problem as you pointed out.

'Check TM Rate for a value
    If ((Me.Project_Type) = "1") And IsNull(Me.TMRate) Then
    MsgBox "Please fill in the Time and Materials Rate before proceeding", vbOKOnly
    Me.TMRate.SetFocus
    GoTo Exit_Procedure
    End If

 

[Frothingslosh]

Ahh, IT WORKS! Thank you so much for the help, I think the Option Explicit may have been the initial problem as you pointed out.

'Check TM Rate for a value
    If ((Me.Project_Type) = "1") And IsNull(Me.TMRate) Then
    MsgBox "Please fill in the Time and Materials Rate before proceeding", vbOKOnly
    Me.TMRate.SetFocus
    GoTo Exit_Procedure
    End If

Glad to hear it! So does the whole thing work now? If not, I'll take a fine-toothed comb to it once I get home from work.

 

[Samantha]

It seems as though it is all working correctly. I can't thank you enough, I would like to understand it all. Some things just loose me all together!

 

[Frothingslosh]

It's not a problem at all. I'm only what this site would consider an intermediate user, and trust me, I use F1 and microsoft's help pages all the frakking time!