Filter only shows first records on subform

E

efandango

I have this code on the 'Filter' property on my form.

I compare either of two field ID's to a single field ID on another continous
subform. All works ok, except when I go to another single field, then I it
doesn't work, or re-filter. How can i get it to re-filter when I select
another linked field.


Run_waypoint_ID_From=Forms![frm_Runs]![frm_Links]![frm_Link_Waypoints].Form![StreetNameID]
Or
Run_waypoint_ID_To=Forms![frm_Runs]![frm_Links]![frm_Link_Waypoints].Form![StreetNameID]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

matching more than one continous form field on other form, possibl 0
Need help with this code to find specific record 9
after update doesn't update secondary field 3
refresh an open form using records from another open form? 27
Filter main form to records with no related records in subform,maintain updateable recordset 4
Master Child link being broken. 2
Master - Child links not working in 2007 0
VBA code returns no records hwenKey ID is added 14

Top