Data in table from a form

J

jeburkard

Access 2003.

Some fields of data on my input form are not getting into the corresponding
table. They are all numbers and some of the data in the table comes up
zeros. It is always the same fields and occurs with every form entry.
 
J

jeburkard

Yes, I don't trust my typing so I either select the "Source" from the field
list or build an expression with the fields available in the query that is
used to build the form.
 
J

John W. Vinson

Access 2003.

Some fields of data on my input form are not getting into the corresponding
table. They are all numbers and some of the data in the table comes up
zeros. It is always the same fields and occurs with every form entry.
Click to expand...

Please post the SQL view of the form's Recordsource, and the Control Source
properties of the relevant form controls.
 
J

jeburkard

Thanks. My problem was that I was using an expression as the source. My
Access 2003 does allow this. If I use a macro to update the fields on the
form, the data does go into the table.

Tom Wickerath said:
Expressions are not updateable (ie. =[Some Field] + [Some Other Field]), and
you should see a status bar message that prevents you from doing so.

You might look through this listing, to see if anything applies:

Why is my query read-only?
http://allenbrowne.com/ser-61.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

jeburkard said:
Yes, I don't trust my typing so I either select the "Source" from the field
list or build an expression with the fields available in the query that is
used to build the form.
Click to expand...
Click to expand...
 
Top