I have a combobox that shows dates for upcoming events. I would like to use a where clause so that no dates older than a month from now will be displayed. Can anyone offer a link or suggestion on how I need to formulate this statement. I have been doing research and have found nothing to fit my situation. thanks

WHERE (((Table.DateOfEvent)>Date()-30));

I think you mean Sam

Thanks it works like a charm. I knew it would be simple... just wasn't so sure about myself on this one. BTW the following is the one that did it for me. Thank you both.

WHERE (((Table.DateOfEvent)>Date()-30));