Command button calculation

[punter]

Hi,

I've been banging on this problem for a week and I just can't get it straight. I know this has to be easy but I can't get the coding or whatever perfect.

I have attached a database. There is a form called BOL_information_entry. There is a command button (Add Record). I don't want the command button to add the record if field Cartons minus field Carton Count Subtotal is anything but zero. The Carton Count Subtotal is in a subform.

I'm looking to have the command button do that calculation and return an error message that says something like "Carton count out of balance". For the life of me I can't get it to work. Any thoughts?

Thanks in advance,

Eddie.

 

[KeithG]

is this what you wanted?

 

[punter]

That is EXACTLY what I need. Thank you so much. I was missing a "-" in my coding. I knew it was something like that.

Again thank you so very much.

Eddie.

 

[KeithG]

Glad I could help!