new to Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am just learning Access 97. I have created a form but it is taking the data
entered in entry 1 and automatically entering it in all entries. How do I
change this? I would like each form to be a place for distinct,
survey-gathered information. Does it have to do with how my form is linked to
a table? Ideally, I would like to enter the data in the form first, and then
have that information be collectively and automatically stored in the table.
thank you.
 
Yes, that is the reason.

Typically, you would not enter the data and then store it like you mention.
Typically you'd build a table and then base the form on that table. The
form wizard will even help you build it.

Creating an unbound form as you request is much more complex and will
probably involve writing vb code to handle the write back to the table.

Start out simple and build a form bound to a table and drag the fields you
want into the form.
 
Ideally, I would like to enter the data in the form first, and then
have that information be collectively and automatically stored in the table.
thank you.
Click to expand...

a form does not store data, it only displays it.
if your form is bound to a table (form's RecordSource property is not
blank), then each record you "enter" in the form is actually being written
to the table when you a) save the record in the form, b) move to another
record or to a "new" record, or to a subform within the main form, or c)
close the form.
if your form is not bound to a table (form's RecordSource property is
blank), then you only have the current data available to edit or save to a
table. you can't enter multiple records in an unbound form, unless you save
the current data to a table before starting a "new record". and you lose the
current data when the form closes, again unless you save the data into a
table.
 
Back
Top