Updating ms access from a form
Collect information from other sources Why force users to navigate away from their current form to look something up when you can present it in their primary workspace?If you can anticipate what your users might be interested to know about a certain record, Access provides a simple set of tools to fetch data from other tables or queries and show it directly on your form.Background Color Consistent Font Use Logical Groupings and Alignment Clear navigation User-centric instead of Data-centric Deemphasizing non-critical information Inline calculations Form window behaviors Summary and Detail Forms Load forms with context Whether you are starting a new database, or renovating an old one, Access Form Design is one of the most entertaining and also important steps.Do it right, and you have a highly functional, productive application with a professional look and feel to hand to your users.Replace with any filter criteria you need to apply. Your text box would look like this:=DSum("Revenue","tbl Orders","[fk_Customer ID] = " & [Customer ID])In the above example, we're summing the Revenue column in the table "tbl Orders," but only if the customer ID indicator in tbl Orders matches the customer ID of the current record on this form.If you see "#Error" you'll know something is wrong.Putting a dropdown box on a detail form to let users navigate between records can be cumbersome to create, and not the ideal way to present information.
This will not apply if you are using Access 2007/2010's tabbed window interface and the form's Popup property is set to "No."This property is set to "All Records" by default.Usually that the field name you specified doesn't exist, or the table/query name is slightly off.Notice in the screen at right, we have several tabs.When needed, you may need to create multiple versions/views of the same information to fit your user's task.For example, a summary form would be ideal to browse a list of products, whereas a detail form might be appropriate for filling out a new order.
The tab control in Access is a fantastic way to deemphasize less important information, reduce the size your form will need to take up on screen, and divide your forms into logical sections.