Solved

Continous form

Posted on 2013-05-16
8
191 Views
Last Modified: 2013-05-18
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.
0
Comment
Question by:pdvsa
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 167 total points
ID: 39173479
set the default value property of field  [hedgeingStrategy] equal to the current value
0
 
LVL 29

Assisted Solution

by:IrogSinta
IrogSinta earned 167 total points
ID: 39173482
What is an example value for hedgeingStrategy?  Would it have a limited number of possible values or can its value be calculated from projid?  If either of this is the case, you can just create a query with the fields from your table and have a calculated field for hedgeingStrategy.  You would then use this query as the source for your continuous form.
0
 

Author Comment

by:pdvsa
ID: 39175112
Capricorn:  that sounds like what I am after.  I went to the field in the table and see default value but not certain how to make it default to "current value".  I typed "Current Value" in the default value but obviously that is wrong.  I clicked the "..." but dont see anything there that says current value.  

let me know.  thanks.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 166 total points
ID: 39175135
the above Experts seem to have you covered..

I am just curious...

<One if the fields is [hedgeingStrategy].   The value of this field will always be the same for each [projid].  .

Then why is this even a field?

Like having a table of Animals, and having a combobox to select: Animal, Mineral, or Vegetable...

JeffCoachman
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 119

Expert Comment

by:Rey Obrero
ID: 39175146
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].
0
 

Author Comment

by:pdvsa
ID: 39175348
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.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39175459
...and just to clarify...
Is:
    projid
...the primary key
0
 

Author Comment

by:pdvsa
ID: 39176285
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
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now