Solved Subform required if main form has created new record (1 Viewer)

[tihmir]

Hi all, I need some help, pleas.
I have main form with name "frmMain" and linked subform with name"subfrmSubForm".
I need to make the subform "subfrmSubForm" and my filed "txtField" on subform required I . So if I have created new record on my main form "frmMain" I am obliged to fill in my txtField which is on the subform.
How to make this with VBA?

 

[bob fitz]

Here's one way to consider.

 

[tihmir]

Here's one way to consider.

Thank you for the advice, bob fitz.
Another thing I need is a warning message if I try to leave the Main form without making a record in the subform textbox.

 

[bob fitz]

Thank you for the advice, bob fitz.
Another thing I need is a warning message if I try to leave the Main form without making a record in the subform textbox.

But it already does that for new records

 

[bob fitz]

Thank you for the advice, bob fitz.
Another thing I need is a warning message if I try to leave the Main form without making a record in the subform textbox.

If you need that, even for existing records, you might do that as I have in the attached db

 

[tihmir]

If you need that, even for existing records, you might do that as I have in the attached db

Тhank you again, bob!
I may not have explained correctly, but what I want is when a new entry is entered in my Main form then I must enter data in my Subform (in my text fields, that are on mine). If I do not enter data and do not create a new record in mine Subform, then I will receive a message "Please enter data in the Subform"

 

[arnelgp]

see if this is the intent.

 

[tihmir]

Тhank you, arnelgp, bob fitz for your help and helpful advice!

 

[arnelgp]

goodluck