Updating ms access from a form
View data types by using commands on the Datasheet tab The data type set for each table field provides the first level of control over what you can and cannot enter into a field.
In some cases, a data type setting prevents you from entering any information at all.
When you design a database table, you select a data type for each of the fields in that table, a process that helps ensure more accurate data entry.
For example, suppose you specify the Number data type for a field because you need to calculate sales figures.
Then check each control to ensure it is linked to the field where you want to save it to in the table.
For instance; if you are using as your table, then it should be visible in the Record Source. Chances are good because this once worked, that the form fields will relink themselves.
In addition, those objects must adhere to a set of design principles or the database will either work poorly or fail altogether.
I had created a form with these (and others in the table) fields.
There is another field Opp Mat which is blank in the table.
I should mention that this is a maintenance problem, as this database was complete and used in previous competitions, but the user needed it to be slimmed down.
I'm an Access 2007 newbie, but everything has been going fine until this.
There were never any macros or events for " came from (to my knowledge at least).