subform with 2 requirements and 2 fields

  • Thread starter Thread starter deb
  • Start date Start date
D

deb

I have a subform that is a continuous form(PK ProjectID). The record source
is a query that limits the field called KeyMilestonesSubID to a choice of 15
or 22.

Ther fields are ProjectID, KeyMilestonesSubID, Unit, ActualDt and OrigDt.

How do I make it a requirement that the user enter KeyMilestonesSubID and
ActualDt for both selections- 15 and 22?

They must select KeyMilestonesSubID 15 and ActualDt and they must also
select KeyMilestonesSubID 22 and the ActualDt
 
Back
Top