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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I would suggest going to the table and making those fields required. Even
though you may have existing data that violates the new rule, you can change
the rule to apply to new records.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


mma40 wrote:
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.


.

Relevant Pages