Filter question (1 Viewer)

[Peter Paul]

Greetings, here I am with yet another question. I have a form with many subforms. On one of the subforms - OffenseInformation - the user selects offense codes for an incident, and is allowed to enter as many codes as apply, (out of about 50.)

On the Victim subform, each Victim must be connected to each Offense which occurred. Herein lies my question. I would like the options in the VictimConnected field to be limited to those incidents which were entered for the incident.

CaseIncidentNumber is the unique number which is used to tie all of the tables together.

Thanks in advance for your help,
Peter Paul

 

[MHM]

Hey Paul,

choose:
1st: Just use the sub-form wizard: It automatically connects one field in the main form to another in the sub form.

2nd: Enter valid field names in the properties of the sub form at "connect from/to" (or similar since I use a non-English version). The sub form only shows records which are in relation to the current record in the main form.

Mic