Modify field on form

[pdtit]

Hello,

I have a form which is used as an invoice input based on a table "articles".
The only info you have to give is the articlenr, which is taken from a select query, and it fills out the description and price.

However, in my articles table, there is an article "general", for which no price is defined in the table. When trying to modify the price for this product on my invoice-form, it says the field cannot be updated.

Any ideas on how to arrange this ?

Regards,

Peter

 

[PaulF]

check out the NZ function

PaulF

 

[formerTexan]

Just elaborating on Paul's solution. You are trying to pass a Null "value" to a field that won't accept nulls. The NZ function (Null to Zero) will convert nulls to ... you guessed it - zeros.

Bill