Amateur Question on Access VBA

[Gliff]

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!

[Hack]

Welcome to DevX

Are you familiar with SQL? Specifically (for this case) SELECT statements?

[Gliff]

I know dibs and dabs of SQL, but i'm afraid not in this scenario.

Thanks though, websites like this are always incredibly helpful!

[Hack]

Well, a SELECT query would return the stock level from the database.

That return would be stored in a variable and compared to whatever you are using on your form to deal with stock.

Transactions that took stock out or put stock in would either increment or decrement that value, and write the new value back using an UPDATE query.