Hi All,

I have a field in my database that is a simple yes/no input. When the user creates a NEW record, they select yes or no from a list menu. There selection is inputted into the DB.

the problem I am having is when I want the user to update/modify the record. I would like the menu to display the value that is already in the DB field (either Yes or No) and then also list the option that is not in the DB (again, either yes or No) so that the user can change it if needed.

I have figured out how to get the current value from the DB into the menu, however I cannot figure out how to get the "other" option into the menu.

Any suggestions?

THANKS

-Peter

In DMX, this is a breeze (in UD4 it was a manual chore).

Create your static items (Yes, No) for your List Menu. (if you are storing 1 and 0 in your database, make sure your static VALUE reflects that).
Click the list menu, and look at your Properties dialogue. Click the Dynamic tab (I have to click it twice for some reason - at least it's consistent!<img src=../images/mxzone/forum/icon_smile.gif border=0 align=middle>
Ignore the 'Options from Recordset' dropdown - your options are all static, and you should see them listed in the Static Options box.
Click the lightening bolt next to 'Select Value Equal To:'
Select the correct recordset and DB field that contains your value.
OK, OK, and you're done!

Ned Frankly
www.nedfrankly.com
You think I ramble on HERE?