Continous form
Experts, i have a continous form with a few fields. One if the fields is [hedgeingStrategy]. The value of this field will always be the same for each [projid].
I want to avoid continually selecting the value for each [projid]. I dont know if this will make sense to you but how can i make the field [hedgeingStrategy] the same for every inserted record in the form (table). Maybe an OnCurrent event or afterUpdate or is there a better approach? I think this is much simpler than i am explaining i think. Thank you.
I want to avoid continually selecting the value for each [projid]. I dont know if this will make sense to you but how can i make the field [hedgeingStrategy] the same for every inserted record in the form (table). Maybe an OnCurrent event or afterUpdate or is there a better approach? I think this is much simpler than i am explaining i think. Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what i mean by "current value". is the value that you want to use as default,
say the value of 100 is the one you said is the same for all Projid
place 100 in the default value property of the field [hedgeingStrategy].
say the value of 100 is the one you said is the same for all Projid
place 100 in the default value property of the field [hedgeingStrategy].
ASKER
oh I see. Wait let me back up. I am not thinking about this deep enough. Jeff has a good point now that I think about it.
What I meant by [hedgeingStrategy] will be the same is that it will be the same for only the [projid] that is in the underlying table. I now think that setting a default value in the table is actually not what I am after.
Sorry for any confusion. I actually wrote the question from a bar last night and probably wasnt thinking clearly and still am not this am. haha
maybe after knowing what I am interested in now, the experts can help me better.
IrogSinta:
<What is an example value for hedgeingStrategy?
==>it is a combo box with various values.
<Would it have a limited number of possible values or can its value be calculated from projid?
==>It is not any number. Only a text value. I continually add options to this combo box (I have a sort of drop box table that stores all the various cbo options)
Hope I am a little clearer now.
What I meant by [hedgeingStrategy] will be the same is that it will be the same for only the [projid] that is in the underlying table. I now think that setting a default value in the table is actually not what I am after.
Sorry for any confusion. I actually wrote the question from a bar last night and probably wasnt thinking clearly and still am not this am. haha
maybe after knowing what I am interested in now, the experts can help me better.
IrogSinta:
<What is an example value for hedgeingStrategy?
==>it is a combo box with various values.
<Would it have a limited number of possible values or can its value be calculated from projid?
==>It is not any number. Only a text value. I continually add options to this combo box (I have a sort of drop box table that stores all the various cbo options)
Hope I am a little clearer now.
...and just to clarify...
Is:
projid
...the primary key
Is:
projid
...the primary key
ASKER
Boag: i have an autonumber as ID which is set as the PK. projid i think would be classified as a FK to tblprojects. Thank you
ASKER
let me know. thanks.