matching more than one continous form field on other form, possibl

[efandango]

I have two forms, the first is a continous form containing a list of
addresses. On another tab I have the 2nd continous form which filters for any
occurance of a matching record in any of two fields that relate to a field on
the 2st form, using this filter criteria:

Run_waypoint_ID_From=Forms!frm_Runs!frm_Waypoints.Form!Run_waypoint_ID Or
Run_waypoint_ID_To=Forms!frm_Runs!frm_Waypoints.Form!Run_waypoint_ID

1st form: Frm_Run_Waypoints
2nd form: Frm_Road_Restrictions

The problem is that the 2nd form will only show records based on one address
on the 1st form. I want it to show ANY matching records that appear on the
1st form. How can I do this?

For example, how can I get it to show ‘Quality Street and ‘South Street’

Frm_Run_Waypoints (Record Run_No 3)
* Denotes record selected with cursor
Run_waypoint_ID Run_waypoint Postcode
45446 Other Other
51772 *Back Lane W2
45346 Other Other
35753 Other Other
32748 Other Other
27461 Other Other
45346 Other Other
38270 South Street N2
27461 Other Other
45346 Quality Street WC2
45841 Other Other

Would show these matching records in:
Frm_Road_Restrictions (record 19)
* Denotes record that appear in 2nd form

ID_From Road_Name_From Postcode_From ID_To Road_Name_To Postcode_To
35753 Other N2 51772 *Back Lane N2
38270 South Street N2 35753 Other Other
51772 *Back Lane N2 45841 Other Other
38270 South Street N2 51772 *Back Lane N2
45346 Quality Street WC2 25671 Other W1

 
Form structure: Frm_Road_Restrictions

Record Source:
tbl_Road_Restrictions

Filter:
Run_waypoint_ID_From=Forms!frm_Runs!frm_Waypoints.Form!Run_waypoint_ID Or
Run_waypoint_ID_To=Forms!frm_Runs!frm_Waypoints.Form!Run_waypoint_ID

Filter on Load:
Yes