Data in table from a form

  • Thread starter Thread starter jeburkard
  • Start date Start date
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.
 
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.
 
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.
 
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...
 
Back
Top