Requiring Data in field on Form with enter new record in Subform

  • Thread starter Thread starter maria.ashby
  • Start date Start date
M

maria.ashby

I have an existing table that I now require certain fields to be
entered which it does with new records. How do I go about making the
user fill in all the missing "required" fields on the main form before
adding a record to the subform. There are about 5 fields that are now
required which were not when the previous person created the table.
Any help would be appreciated.
 
Hello Maria,

You need to set the fields to "Required".

Go to the original table + design view
Choose each field and in the Properties at the bottom change Required from
No to Yes.

If you have any problems please repost

Hope this helps

Judith
 
Back
Top