Info entered in form goes to table, but not saved in form

  • Thread starter Thread starter kjss via AccessMonster.com
  • Start date Start date
K

kjss via AccessMonster.com

Ok..so I was on yesterday, and I received some gracious assistance, and after
really working on it, I can't figure it out still. Basically, I am not able
to enter info into my form and have it save in the form. The info goes to
the table, but it doesn't create a new record in the form. Any ideas? All
of my editing settings are on "yes."
Why does the info go into the table, but not viewed in the form.
 
My guess is you have the Data Entry property set to YES as well. Set it to
NO.
 
Unfortunately, the data entry is already set to "no." Basically, I can enter
all the info I want, but when I close the form and reopen, it's gone. The
mystery is that the info is captured in the table.
 
Data is not saved in a form. A form is only a way to view, add, or edit data
in tables. If a form is defined as Data Entry, it opens with a new (blank)
record; otherwise, it opens with the first record in the form's recordset.
If the data is in the table (have you looked?) and the table is the record
source for the form and you are not doing any filtering at the form level, it
will be there. If you are using a query based on the table as the form's
recordsource and there is any filtering at either form or query level, you
need to be sure any filtering will not exclude the new record.
 
This makes absolute sense...the info is in the table even though the form
comes up blank. One question, though, I have created a DB in the past that
allows me to edit and make changes in the form that are both visable in
numerous records in the form as well as in the table. Am I missing something
here?
Data is not saved in a form. A form is only a way to view, add, or edit data
in tables. If a form is defined as Data Entry, it opens with a new (blank)
record; otherwise, it opens with the first record in the form's recordset.
If the data is in the table (have you looked?) and the table is the record
source for the form and you are not doing any filtering at the form level, it
will be there. If you are using a query based on the table as the form's
recordsource and there is any filtering at either form or query level, you
need to be sure any filtering will not exclude the new record.
Unfortunately, the data entry is already set to "no." Basically, I can enter
all the info I want, but when I close the form and reopen, it's gone. The
Click to expand...
[quoted text clipped - 9 lines]
Click to expand...
 
I am not sure what you are asking.

kjss via AccessMonster.com said:
This makes absolute sense...the info is in the table even though the form
comes up blank. One question, though, I have created a DB in the past that
allows me to edit and make changes in the form that are both visable in
numerous records in the form as well as in the table. Am I missing something
here?
Data is not saved in a form. A form is only a way to view, add, or edit data
in tables. If a form is defined as Data Entry, it opens with a new (blank)
record; otherwise, it opens with the first record in the form's recordset.
If the data is in the table (have you looked?) and the table is the record
source for the form and you are not doing any filtering at the form level, it
will be there. If you are using a query based on the table as the form's
recordsource and there is any filtering at either form or query level, you
need to be sure any filtering will not exclude the new record.
Unfortunately, the data entry is already set to "no." Basically, I can enter
all the info I want, but when I close the form and reopen, it's gone. The
Click to expand...
[quoted text clipped - 9 lines]
of my editing settings are on "yes."
Why does the info go into the table, but not viewed in the form.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top