How do I Make Control Required

[M Erenberg]

This question is a twin to How do I Mandate the Tab Order for a Control within a Subform's Form but asks a separate question.

I have a form and a sub form which I use to track customer complaints. The main form has static data such as account number name of caller, date of call and reason for call. The sub form is used for notes. Since follow-up is sometimes needed there is a many-to-one relationship between notes and complaint tracking the update date of the note. I have two questions:
1. is found in the twin thread.
2. How do I make the note control required in every instance?

I tried making the note required in the table/field definition and that did not work.

[patjones]

I don't understand what you mean by 'mandate the tab order for the note'. As for requiring entry in the note field...what does the user do to save the record? For example, if the user saves the record by hitting a 'save' button, you would put a check in the code that looks to see if the field is null - and if so raise a message telling the user to enter something in the field.

[NeoPa]

M Erenberg:
I tried making the note required in the table/field definition and that did not work.

Please explain exactly what you did here as this should at least have ensured no records were ever saved with empty Note fields.

It may also help if you explain the table structure of the data you're trying to work with. Helping within an information vacuum is notoriously complicated.

[NeoPa]

I've just deleted your new thread as it's a regurgitation of these two without making anything too much clearer. One thing I was able to deduce though, and I'm not absolutely sure of this, is that you seem to describe a separately opened form as a subform in your question. Subforms are form controls that show forms embedded within them. In no way are they separate forms which are managed distinctly as you (possibly) seem to understand.

Let's get something sensible here pretty soon as it's unclear what's going on.