twistedsistem
Registered User.
- Local time
- Today, 10:15
- Joined
- Mar 8, 2007
- Messages
- 10
This may need to be moved to the query section instead of the form section but I figured I would start here.
My co-worker and I have a database that has radial buttons in a form that go in assending order so if you click the first we have it setting a variable to 1 and if you click the second we have it setting a variable to 2.
Our problem is that we want to have it so that if you click on the second one it will put in the variable the expression IN(1,2). We set up a test that shows that our formula is working but we want that expression to be put into the criteria section of a query. Well when we put in the expression to pull from the form it gives us a property not found error. But if we hardcode in the expression it works perfectly. Does anyone know another way around this?
My co-worker and I have a database that has radial buttons in a form that go in assending order so if you click the first we have it setting a variable to 1 and if you click the second we have it setting a variable to 2.
Our problem is that we want to have it so that if you click on the second one it will put in the variable the expression IN(1,2). We set up a test that shows that our formula is working but we want that expression to be put into the criteria section of a query. Well when we put in the expression to pull from the form it gives us a property not found error. But if we hardcode in the expression it works perfectly. Does anyone know another way around this?
