Thanks a ton, man. That worked out for me. I had to tie the filter to the last name instead of the numerical primary key I used in the first place. It just seemed to not work with numbers and gave me a data type error. Also, it won't filter correctly if that form is already open. Would you...
Thanks mate, I'm just not seeming to grasp how to make clicking it bring me to a different form view I have. Its basically a list of employee's (or providers in my case) that are in a list form as a subform. This is when the user is surfing different offices and sees who works within that...
I have a subform that contains multiple items, a list of records we also have in a form view that shows 1 record at a time. I have all the relationships and ID’s are matching in the tables. For example, I have a subform that contains all current providers working for the currently selected...