If Then Else Statement does not work.

Codesmith

New member
Local time
Today, 21:49
Joined
Apr 19, 2001
Messages
7
Im developing a database for sales and I cant
for the life of me get my if then statements to work. I am familiar with programming in basic, but it does not seem to be working properly. I have a combo box that updates a number of other fields, it is not limmited to the list. when someone enters a non listed number into the combo box, all the default values become nulls in the updated fields.

this is a small section of my code:

If [Part_Description] Is Null Then
[Part_Price] = 0
End If

can someone tell my why this simple statement produces an error 424 object required?

[This message has been edited by Codesmith (edited 08-07-2001).]
 
maybe try:


If IsNull([Part_Description]) Then
Me![Part_Price] = 0
End If
 

Users who are viewing this thread

Back
Top Bottom