I'm sure this is easy for someone who knows what they are doing. If there's already a post that answers this, please let me know.
I have a Service table with a unique service id, a service text description, and an expiration date. Then a Request table stores the service id for the request.
When the users view the Request form, I have a combo box for the Service. I want to show the service text description for the services selected, even if that service has expired. But I only want the drop down to list the services that have not expired.
I know how to show the service text description without factoring in the expiration date. But when I change the Row Source to only show where the expiration date is null or >= NOW() my drop down lists the correct services, but then I don't see the text for any of the expired services in the text field part of the combo box.
Old Requests have services that were valid at the time they were entered, so I need to see them, but new Requests should not be able to choose expired services.
Does this make sense?
kdk13
I have a Service table with a unique service id, a service text description, and an expiration date. Then a Request table stores the service id for the request.
When the users view the Request form, I have a combo box for the Service. I want to show the service text description for the services selected, even if that service has expired. But I only want the drop down to list the services that have not expired.
I know how to show the service text description without factoring in the expiration date. But when I change the Row Source to only show where the expiration date is null or >= NOW() my drop down lists the correct services, but then I don't see the text for any of the expired services in the text field part of the combo box.
Old Requests have services that were valid at the time they were entered, so I need to see them, but new Requests should not be able to choose expired services.
Does this make sense?
kdk13