Can anyone tell me if it's possible to have a checkbox automatically check a value(s) based on a lookup?

Edited March 21, 200817 yr by Guest

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.

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.

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.

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.

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, 200817 yr by Guest