I need to require that certain fields in a form be populated before a user can move on to the next record in that form.
I included the following formula in the BeforeUpdate property for the form:
=IIf(IsNull([Combo40]),MsgBox("Please select a value for SAP Adjustment required"))
I've tested this formula and it works. The problem I have is when I click OK on the message box the form advances to the next record. I would like to keep the same record visible that prompted the message.
Can anyone advise how I do that? Is there something wrong with my formula or do I need to do something else?
Thanks!
I included the following formula in the BeforeUpdate property for the form:
=IIf(IsNull([Combo40]),MsgBox("Please select a value for SAP Adjustment required"))
I've tested this formula and it works. The problem I have is when I click OK on the message box the form advances to the next record. I would like to keep the same record visible that prompted the message.
Can anyone advise how I do that? Is there something wrong with my formula or do I need to do something else?
Thanks!