I am reaaallly not good at code, but am realizing that cannot do without it either anymore.
So the issue is that I have an application form using input fields connected to a dataset collecting the information from applicants. One of those input fields is a drop-down list connected to another dataset that has the event title in it. I need to keep the old events in the dataset for archive reasons, but I need them not to show up in the drop-down so that it wouldn't confuse the applicants and create a crazy long list after a while. I'm sure that there is a code that would add a condition only to display future events in the drop-down, but I really do not understand how to make that happen. So I thought I could fix this by adding another field to the event dataset where only the future event tites are copied in, the past ones are empty - but the conundrum now is that the empty ones still show up, only blank - this will still create a strange long list below the active events. And they can be clicked by accident that would confuse the application information further.
So is there a way to hide old events drop-down list in this situation either by date condition of by hiding empty fields? I am open to try whichever is simplest for me to actually achieve. However, I do realize that the date solution would be much more efficient. Sincere thanks for patience and help beforehand! :)