The_Vincester
Registered User.
- Local time
- Today, 14:44
- Joined
- Jun 6, 2006
- Messages
- 71
I have a form with several option groups, that when selected, store values in fields.
Let's say one option group has the options of:
A - D - VL - M - ADD
If I select "D" then D is stored as a value.
OK, now that we have that. The thing is, this forms need to be updatable. As it is, when I reopen the form, the corresponding "D" which was previously selected, no longer is. That makes sense to me, since the actually value of the button 2, not really "D".
So how do I fill in this option when reopening the form?
The long way, which I would prefer not do to seems to be create individual buttons and fields for each other, with a Yes/No field to store the state of the button and a text field to store the value. If I do this, my table will have about 200 fields, and I don't think that's acceptable.
Let's say one option group has the options of:
A - D - VL - M - ADD
If I select "D" then D is stored as a value.
OK, now that we have that. The thing is, this forms need to be updatable. As it is, when I reopen the form, the corresponding "D" which was previously selected, no longer is. That makes sense to me, since the actually value of the button 2, not really "D".
So how do I fill in this option when reopening the form?
The long way, which I would prefer not do to seems to be create individual buttons and fields for each other, with a Yes/No field to store the state of the button and a text field to store the value. If I do this, my table will have about 200 fields, and I don't think that's acceptable.
