Syntax Issues

[ijit]

Hey, I am still learning the syntax in VB. This is saying that the types don't match up.

CurrentDb.Execute "DELETE * FROM ItemList WHERE ([ItemKey]= & Me.ItemKey & )"

ItemKey is a number. How would I write this?

 

[pbaldy]

The form reference needs to be outside the quotes so it can be evaluated:

CurrentDb.Execute "DELETE * FROM ItemList WHERE ([ItemKey]=" & Me.ItemKey & ")"

 

[ijit]

It worked perfectly, thanks.

 

[pbaldy]

No problem; by the way, the parentheses around the WHERE clause are not necessary. This should work equally well:

CurrentDb.Execute "DELETE * FROM ItemList WHERE [ItemKey]=" & Me.ItemKey