Solved Subform required if main form has created new record

tihmir

Registered User.
Local time
Today, 05:23
Joined
May 1, 2018
Messages
257
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?
 
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.
 
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
 

Attachments

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"
 

Attachments

see if this is the intent.
 

Attachments

Users who are viewing this thread

Back
Top Bottom