|
|
![]() |
| Thread Tools | Search this Thread |
#1
| |||
| |||
How to Automatically access the fields of an Access 2007 forms I'm trying to figure out how to get Access 2007 to fill in one field based on what is put in another field that means it would be automatic that if it has been updated on one field of a sheet,then it should be updated on the other desired filed. I am trying to format a form in Access where users could check off a box and have the home address. |
#2
| |||
| |||
Re: How to Automatically access the fields of an Access 2007 forms AutoFormats in Access 2007 let you do more than just apply an existing format, however; you can choose which elements of an AutoFormat to apply, create new AutoFormats to match the formatting of an existing form or report, or modify an existing AutoFormat.
|
#3
| |||
| |||
Re: How to Automatically access the fields of an Access 2007 forms You may place any number of combo boxes on your form as per your requirement. ---------------------------------Employee Combo Box--------------------- Properties Name: Combo1 Control: Employee Row Source: SELECT * FROM ...................(Table name VBA) Combo1_AfterUpdate() Me.Combo2.Requery (and the below you may use the function on which you want to update the field) ------------------------------------------------------------------ |
#4
| |||
| |||
Re: How to Automatically access the fields of an Access 2007 forms you can apply one of the AutoFormats installed with Access, Access provides a convenient spreadsheet-style datasheet view for entering data into form, it isn?t always an appropriate tool for every data entry situation.You can change the appearance of individual elements in your Office Access 2007 objects, but an easier way to change the format of an entire form or report at once is to use an AutoFormat that is included with Access. If you?re working with users you don?t want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. |
![]() |
|
Tags: access 2007, automatic updates |
Thread Tools | Search this Thread |
|
![]() | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
In Access 2007 I need to combine multiple tables into 1 having identical fields | djbbenn | Software Development | 4 | 09-05-2012 09:21 PM |
Access 2010 file in Access 2007 gives Unrecognized Database Format | Roakman | MS Office Support | 3 | 11-12-2010 11:45 PM |
Mouse wheel does not work properly in forms of Access 2007 | mahaFEB | Windows Software | 5 | 30-11-2010 11:21 PM |
How to add two fields in ms access? | lootera | Windows Software | 3 | 03-09-2009 09:18 PM |
Access does not allow Primary key with two fields | Reckon | Networking & Security | 2 | 16-06-2009 03:48 PM |