Preparing linked form for use.

I have a membership database where new members register on a website
and I download a CSV so that I can work on the data.

I have a subform linked by MemberID that keeps subsidiary information
for my use. Several of the fields on the subform are yes/no fields.
When I have a new member the sub form has no data and the yes.no
fields are greyed out.

Currently I tick the first field and then untick it to have the yes/no
fields active. This is obviously archaic and there must be a better
way. An important field is [DateWecomed] which needs to be populated
when I open the new member record for the first time. I believe that
if I had code to populate that field the yes/no boxes would be active.

Your suggestions are welcome.

Many thanks,

Robin Chapple


.