what if scenario need help!!!

[imacamelshump]

Hey guys need you help, The following is what i got
txtbox - Project_Code
txtbox - Status

Status = Active, Complet, Finished, Under_Development

This is the scenario i need to code for on update for the status text box so that if status is Active, Complete or finished then there MUST be a project code and if status is Underdevelopment that there cant be a project code, and it cant let you leave the record until it is correct,

ive tried and tried to code it but im getting know where can anybody please help me,

any help is grately appreciated

 

[RivetHed]

Hi I think you need something like this in the on update event procedure

if TxtStatus = ("Active" or "Complete" or "Finished&quot then

if len(Txtproject)<1 then
msgbox &quot;Project Code Required&quot;
cancel = true
end if

elseif len(TxtProject)>0 then
msgbox &quot;No Project code required&quot;
cancel = true
end if

 

[SkipVought]

Hi,

Try this...

    Select Case TxtStatus
        Case "Active", "Complete", "Finished"
    
            Select Case Len(TxtProject)
                Case Is < 1
                    MsgBox &quot;Project Code Required&quot;
                    cancel = True
                Case Is > 0
                    MsgBox &quot;No Project code required&quot;
                    cancel = True
            End Select
    End Select

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[imacamelshump]

hey guys thanks for the code,

when i go to compile its giving me a compile error with cancel = True!!!!!!

 

[TonyJollans]

Hi imacamelshump,

What application are you in and where are you putting the code?

I'm guessing it's Access .. and you should have the code in the Form's BeforeUpdate event.

Enjoy,
Tony

 

[imacamelshump]

yeah, i was putting it in the after update one, but i will try it in before update and see what happens, thnx