I have a form that displays the support staff for a client. If the support staff leaves I would still like the name to show when the client is pulled up. But I don't want it to show in the dropdown menu when a user wants to assign a support staff.
On the record source for the form I link the tblClient (has Support Staff Id #) with the tblLkUpSupportStaff (links via ID# but has the actual name) and display the name on the form. For the dropdown menu I just use the lookup table and tell it to only include if active. It works if the client is Active but when I make them inactive it no longer displays the name. I guess the filter on the dropdown affects the form. Is there a way to fix this? If so how? Thanks!
Start Free Trial
