Making a field required in a sub-form

[ba4crm]

I have a sub-form, in another form, that is the sub-form for a main form (form, sub-form, sub-form). The 3rd form is where a user enters the status of the record and associated notes. The status is via a combo box. I want this form to always have the status - that is the user cannot enter the notes without a value in the combo box (<> Null). I know that using recordsets would make it easy - but that is beyond my expertise. Before creating a new entry, how can I check if the status field has a value and if doesn't, display a message and prevent the user from creating that required. I am using Access 2000/2003.

Thanks

 

[RuralGuy]

Don't enable the Notes control until a status has been selected.

(RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro
Please respond to this forum so all may benefit