Relationship Question

[Collins]

I cannot get this work. Maybe it's not possible. I'll try to explain it and hopefully someone can figure this out.



I have a table with 200 intersections in it. So my Intersection Form has 200 records. I have a crashes table with several crashes I want to link to each intersection making 2000 crash records in my Crashes Form. Now... When I have my Intersection Form open I can navigate to say record 10. The intersection of 5th and Maple and I know that over the years it's had 20 crashes. On the Intersection form I have a button that when I click it, it opens the Crashes Form. But when the Crashes Form opens it doesn't just show me 20 records for 20 crashes for the intersection of 5th and Maple. It shows me 2000 records for all the intersections and starts at record 1 of 2000.

How do I get the form to show just the 20 crashes for that specific intersection instead of all the crashes for all the intersections?

Is it a relationship thing? Can this even be done?

Thoughts anyone?

[pbaldy]

Sounds like this would work:

http://www.baldyweb.com/wherecondition.htm

[Collins]

Thanks Pbaldy. But you have opened many other questions. LOL... Where does this code go? In the button properties? In the field properties? Also would I be able to add a record on the second form and still have it linked to the record in the first form?

[pbaldy]

Behind the button from your description:

http://www.baldyweb.com/FirstVBA.htm

You'd have to do something do keep new records linked. One way would be referring to the first form in the default value property of the textbox for the intersection.

[Collins]

Sweet Baldy I'll give it try!!!

[pbaldy]

Happy to help!

[ssanfu]

Another option:
You could make the "Crashes" form a subform of the "Intersections" form. Then there is no code involved.