subform with 2 requirements and 2 fields

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
 

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

Similar Threads

subform with two requirements and 2 fields 4
query help 1
show if has two specific records 3
must have 2 records in subform 9
Can't figure out query 0
If field =15 save in two tables 2
complicated subform beforeupdate 1
triggers duplicate msg if change is made 2

Top