Subform Record Selection

  • Thread starter Thread starter SME
  • Start date Start date
S

SME

I currently have a form with an agency, which contains a
subform for an application(s), which subsequently
contains 3 subforms for scores returned to the
application. (Essentially 3 tables ... agency,
application, scores)

I would like to display the agency, and the
applications ... so far no problem. I would then like to
display the three scores being returned.

I set up three different subforms which reference the
same query and link the subforms by application number.
For data entry purposes they work fine, I can add the
three different scores just fine.

The problem comes up when scores have been previously
entered ... then the three subforms display the same
record three different times.

If scores have been entered, I would like to have the
three subforms display different information, but still
be able to do data entry for scores which have not been
entered.

Is this possible?

Many many thanks in advance for any help you might be
able to offer.
 
Hi SME:

Have you checked the form's "DataEntry" property and changed it to "yes"?
This will hide all old entries...

Regards,
AL
 
Back
Top