Solved

Continous form

Posted on 2013-05-16
8
228 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

726 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