On Click text box, directed to same record other form

[SoxPats83]

That Did It! Thank You very much! and i appreciate the help from everyone!

 

[SoxPats83]

alright, i now have another one. very very similar to my first request except instead on on click, i am looking to do on open. this time for a sub form of thefirst form i referenced earlier that i am being directed to from my above onclick command. once again, help is appreciated.

 

[John Big Booty]

Sorry not quite sure I understand what you are trying to do here Could you step us through what you want to do.

 

[SoxPats83]

sure, in my previous question i was looking to click on a hyper link to pop up another form that had a value in a matching field to that of the hyperlink clicked. in this new pop up i have yet another form (3rd form) being used as a sub form. this sub form also has the field in it that the first two has that matches perfectly. i would like this sub form to be filtered to find the matching value, very similar to the hyperlink being clicked and filtering through form #2 to find the record that contained the values matching value.

 

[SoxPats83]

seeing as it is a sub form, maybe an on load?

 

[John Big Booty]

Given that it is a sub form, IF you have set it up with the correct Parent records Child record relation ship this should automagically happen when the main form opens. ie. the records shown in the sub form should only be the ones relevant to the (parent) record in the main form.

 

[SoxPats83]

duh, easy fix. thanks a bunch!