|
View Full Version : Setting a value to an option box gbanks 04-25-2006, 06:55 AM I made on option box on a form called Status. The 2 radio buttons are marked Open = 1 and Closed = 2. Is it possible to open a query based on what the user selects. In the query I want open to stand for Is Null and closed would be Is Not Null. I know this sounds unusual but it works in the query they way I want it to. Is this possible? Thanks... KeithG 04-25-2006, 07:01 AM You could use the AfterUpdate event to open the query with docmd.openquery Mickster 05-15-2006, 10:41 AM I made on option box on a form called Status. The 2 radio buttons are marked Open = 1 and Closed = 2. Is it possible to open a query based on what the user selects. In the query I want open to stand for Is Null and closed would be Is Not Null. I know this sounds unusual but it works in the query they way I want it to. Is this possible? Thanks... Hey I am trying to do the same thing but with True and False. Have you come up with a solutions? Thanks |