Auto insert data from form to table

J

jcinn

I created a form in Access 2003 using data from an existing table. I enter
new data in the form and most of it auto inserts in the table. But some of
the fields do not seem to work. I did not create the table or macros--if
that is what was used--that would tell the data to also insert itself in the
same fields in the table. How can I tell the data I insert in the form to
insert in the same fields in the table automatically? Thank you.
 
R

Rick B

If the form and it's fields are bound to the table or a query which is tied
to the table, then the updates just happen. There is no macro or code
involved. If you have a field that is not bounf, then you must use code to
update the table. It would be rare to see both types of fields on one form
if the data resides in one table. Did you add this field that is not
updating? What type of field is it? What is in the field's "control
source" in the "Data" tab of the properties box?

Rick B
 
J

jcinn

The fields in the form duplicate the fields in the table. We converted from
'97 to 2003, which is when I created the form, and when problems began to
occur. Most of the fields populate correctly in table after I enter the info
in the form.

Background:

My predecessor entered new data in a query log that is linked to a table.
Some of the fields auto-populate in the query log (based on info previously
entered in the table) after I type a few characters. If information for a
new record is not already in the table, I have to exit the query log, open
and enter the info in the table, go back to the query log, and then the field
will auto-populate after I type a few characters. I created the form to
enter new records because the interface is more attractive than a table.

Problem:

All of the information entered in a field on the form should populate/link
to the table after entering a few characters. For some fields that happens,
but for some fields it will not. I do not know how to correct.

Wish List:

I would like to update information contained in some of the fields for many
of the records. For instance, a lot of the information in the table, such as
addresses, are not current. I want to create a prompt (for lack of a better
word), that would ask me to confirm the address if the same vendor will be
used for the new record. If the address is current for the new record, I
would say "yes," and move on to the next field. If the address is not
correct, I would say "no" and would input the updated information that would
then auto-insert into the table.
 
J

jcinn

No, I did not add the field that is not updating, but will have to add a new
field that should be updated. For the new field, my thought is to add the
field to the table, then add the field to the form. Thank you.
 
Top