View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Deb Deb is offline
external usenet poster
 
Posts: 102
Default subform with 2 requirements and 2 fields

Wrong posting please ignore
--
deb


"deb" wrote:

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
--
deb