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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top