Setting Status in Outlook Task from Access Form

[GeminiG]

Hi All,
I have a form that assigns a task in outlook. I have all the code working correctly but I need to set the status based on the combo box selection. What I want to do is something like

[FONT=Calibri].Status = if Me.Status = "Not Started" Then "0" else if Me.Status = "In Progress" Then "1" end if[/FONT]

in the "With outlookTask" portion of my code that runs when the forms button is clicked. The code above is incorrect I'm guessing I can't do an if statement in that portion. Any ideas?

 

[Micron]

Sound right. I'd Dim a variable for status (Dim strStatus As String) at the beginning and use

If Me.Status = "Not Started" Then  
  strStatus = "0" 
Else 
  strStatus = "1" 
End if

This assumes:
1 and 0 are string values, not numbers. If they are numbers, you have a looming data type error.
There are only two choices in the combo thus you don't need "else if Me.Status = "In Progress" Then"

In the With block...
.Status = strStatus

 

[GeminiG]

Thanks so much for your help. It works perfectly!

 

[Micron]

Glad to know that. Good luck.