A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old July 19th, 2008, 03:17 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.queries
efandango
external usenet poster
 
Posts: 489
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.