GTIFreak Posted March 21, 2008 Posted March 21, 2008 (edited) Can anyone tell me if it's possible to have a checkbox automatically check a value(s) based on a lookup? Edited March 21, 2008 by Guest
mr_vodka Posted March 21, 2008 Posted March 21, 2008 If the value is entered into the field as part of the lookup and its a part of the value list that you are using for the checkbox then it should display.
GTIFreak Posted March 21, 2008 Author Posted March 21, 2008 That's what I thought, but it isn't working for some reason. If I enter values when the field is set as just an edit box and then change it to checkboxes, no values are checked. But when the field is set to checkbox and I check a few values, the values show up when the field is changed back to an edit box.
comment Posted March 21, 2008 Posted March 21, 2008 If you enter a value that is a member of the value list, it will be displayed as checked. It makes no difference how or when you have entered the value. If the value doesn't show, then it's not in the value list - check for things like trailing spaces.
mr_vodka Posted March 21, 2008 Posted March 21, 2008 Please post an example of how you would type it into the edit box. Apple Orange Grapes should have those values checked if the value list matches them exactly.
GTIFreak Posted March 21, 2008 Author Posted March 21, 2008 (edited) To quote Michael Bolton, "I must've put a decimal point in the wrong place or something. S**t, I always do that. I always mess up some mundane detail." All is better. When I made my value list I left a space after each value before the carriage return. ******* mundane details. Thanks for turning on the lights Mr. Vodka! Edited March 21, 2008 by Guest
Recommended Posts
This topic is 6091 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now