Unanswered: Access 2007 Opening a form based on a query
First post here and found that you chaps and chapettes seem to know what you're talking about compared to the rest of the places I have been.
I am using Access 2007 which is a challnege compared to my Access 2003 skills but I want to be able to open a form that is based on a query. I can do simple queries but the one I want is slightly trickier and I am not sure how best to do it.
I would like the form to show records that DO NOT have a value in the Closed Date field (which is one of the fields in my table). If it does have any date value of any kind then I don't want that record to be viewable by the user browsing through the records.
Anyone any ideas how I can do that? Im sure someone will tell me its a doddle!
I think I might need something slightly different...
I have a form that loads with a single button - you click it and it loads the form to enter customer details. What I want to happen is when that form loads for it to NOT show any records that have a Date Closed entry? I want to stop users from making changes to records that are dead...