Originally I had a sub-form with a Table as the RecordSource but I couldn't get the records to sort chronologically using the date field without having to apply the filter everytime I opened the form. Having read through the posts I changed the RecordSource and linked it to the query but now the combo boxes (there are two - one for ContactTitle and one for State) won't let me select from the list of options.
|
|