Udate: If then queston

  • Thread starter Thread starter jake
  • Start date Start date
J

jake

I need update my subform if the combobox militarybenefits = yes
If militarybenefits = "no" I don't want anything to happen.
I get an error with the following code:
+++++++++++++++++
If Me.MilitaryBenefits = "Yes" Then
CurrentDb.Execute "INSERT INTO todo([CaseNum],[To do
Item],[notes])Values('" & Me.CaseNum & "','" & Me.Headstone & "', '
Order ' );"

Else

End
++++++++++++++
Thanks for your help.
Jake
 
Hi Jake

We know a bit about Access here, but we're not clairvoyant. What is the
error message?

For a start, I can tell you that the "End" should be "End If" and the "Else"
is unnecessary.
 
Thanks for writing Graham,
I figured it out this afternoon. These access groups are a great
resource.
Jake
 
Back
Top