Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

form fields not saving to table

0 views
Skip to first unread message

Kim

unread,
Jan 6, 2010, 9:51:01 AM1/6/10
to
I have created a database with a form and three of the fields are not saving
the information to the table. I have checked the row and control sources and
now at a loss and thoughts?


KARL DEWEY

unread,
Jan 6, 2010, 11:06:02 AM1/6/10
to
As you scroll through existing records is the data of the table displayed?

Post the SQL of the query or form source.

--
Build a little, test a little.

John W. Vinson

unread,
Jan 6, 2010, 11:54:29 AM1/6/10
to

What is the Recordsource property of the form? If it's a query which does not
include the fields, or the fields are in some other table, you'll get this
effect.

You may also be having a problem if these are Lookup Fields, which appear to
contain text but actually contain concealed numeric links.
--

John W. Vinson [MVP]

0 new messages