I have an odd dilemma on my hands... I have a form in my db, let's call it "staffed employees". on this "staffed employees" form, i have a sub form, let's call that "employees w/o". the "employees w/o" form is designed in data view and one of the rows is a hyperlink (done in form design view properties, not in table design view). there is also a third form, not linked to either of these first two, called "close w/o". in the "employees w/o" form there are fields in the record source and displayed on the form itself that are identical to fields in the record source and displayed on the "close w/o" form. my goal here is to click on a hyperlink for a specific record on the "employees w/o" form, say "w/o # 54564" and for that to direct me to the form "close w/o", but not only bring me to that form but to filter all records, so only the record with the matching w/o # is displayed.
i apologize for the running on and possibly losing someone here. this problem is really driving me crazy. any help would be appreciated. Thanks!
i apologize for the running on and possibly losing someone here. this problem is really driving me crazy. any help would be appreciated. Thanks!