StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4578287
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-01-02T12:10:28.697
FavoriteCount
0
LastActivityDate
2011-01-02T12:10:28.697
LastEditDate
LastEditorUserId
0
OwnerUserId
2548
ParentId
4577690
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
If you have a form and wish to update a control to the result of two other controls, you can set the Control Source to ( <a href="http://office.microsoft.com/en-us/access-help/create-an-expression-HA001181384.aspx" rel="nofollow">http://office.microsoft.com/en-us/access-help/create-an-expression-HA001181384.aspx</a> ) : <pre><code> =[Control1]+[Control2] </code></pre> Control1 and Control2 can be bound to Field1 and Field2 by setting the Control Source for each to the relevant field name, however, you cannot bind that Control3 to Field3 because it is already set. If you wish to update Field3 on a form in this way, you need to use code in an event, the After Update event of Control1 and Control2 may suit. It is against normalization rules to store calculations, so you must consider if this is what you wish to do. In Access 2010, you can create a caluclated field (column), which is a different thing, in that it takes care of its own updating : <a href="http://msdn.microsoft.com/en-us/library/ff945943.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ff945943.aspx</a> As for default values, there are a few things to consider: <ul> <li>You cannot set the default value in a table, AFAIK, to Field1+Field2</li> <li>The DefaultValue property is applied only when you add a new record. If you change the DefaultValue property, the change isn't automatically applied to existing records</li> <li>If the controls are on the same form, the control that's the source of the default value must appear earlier in the tab order than the control containing the expression.</li> </ul> Also consider, if you use: <pre><code>=Field1 + Field2 </code></pre> You are referring to the underlying fields in the table, and this can lead to problems if Field1 and Field2 also appear on the form and can be updated. It would be better to use: <pre><code>Me.MyControl.DefaultValue=Control1+Control2 </code></pre> Where the controls are bound to Field1 and Field2. In VBA, this will mean that the default value will be set to the result of the calculation, which is unlikely to be what you want, more probably you want: <pre><code>Me.MyControl.DefaultValue="=Control1+Control2" </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POsum in ms-access
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USFionnuala
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. CONote that adding two values will produce Null if either of two is Null. Judicious use of Nz() may be helpful.
 singulars
 PostPostId
 PO
 UserUserId
 USDavid-W-Fenton

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.