If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
matching more than one continous form field on other form, possibl
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.Fo rm!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 structu 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.Fo rm!Run_waypoint_ID Filter on Load: Yes |
Thread Tools | |
Display Modes | |
|
|