Afternoon All.

I bet this probably comes off as a really newbish question, but I'm completely stuck!

I'm using VBA in Access 2000, and i'm trying to create an IF statement on an Access Form. What I'd like to do is create the statement using the field (Stock Level) from the Table 'tblStock'. I'd like it so that when Stock Level is equal to 0, a Message Box opens and says the name of the Product (Which is located in the Product field of tblStock).

I have the If code working with regular numbers, but I can't use it with data that can be found within fields that I've created.

Any help would be appreciated for a lifetime!

Thanks!