Can't save data in form view

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

Guest

Hi, I've created 2 separate forms in my database. I can type data into them
in form view and click save. However, when I reopen my forms, the data has
not been saved. What is wrong with my forms?
 
Are you saying your forms have a <Save> button on them? If so, what code do
you have "behind" the button click event?

Are your forms bound to any tables? An unbound form has no place to save
data entered into it.

Regards

Jeff Boyce
<Office/Access MVP>
 
Hi Jeff,

My form does NOT have a <Save> button on it. I merely type in my data and
hit enter until I get to the last field on the form. I hit enter one last
time. I have then tried clicking the save button on the standard toolbar and
then closing out of the form. I have also tried just closing the form. In
both cases, when I reopen the form, the data I entered is gone. My form is
based on an underlying table. Any help you can give me would be appreciated
greatly.

Thanks,
feisty quail
 
feisty said:
Hi Jeff,

My form does NOT have a <Save> button on it. I merely type in my
data and hit enter until I get to the last field on the form. I hit
enter one last time. I have then tried clicking the save button on
the standard toolbar and then closing out of the form. I have also
tried just closing the form. In both cases, when I reopen the form,
the data I entered is gone. My form is based on an underlying table.
Any help you can give me would be appreciated greatly.
Click to expand...

Have you looked in the table? If your form has DataEntry set to Yes it does not
show existing records.
 
DataEntry is set to "No", and the records in my underlying table show up in
the form. I just can't add and save new information in form view for some
reason.
 
feisty said:
DataEntry is set to "No", and the records in my underlying table show
up in the form. I just can't add and save new information in form
view for some reason.
Click to expand...

And you get no errors?

Are you checking the record count to test that the records are getting saved or
are you assuming that they will be at the end of the record set? There is no
guarantee that they will show up in any particular place unless you are
explicitly saving a field that you can sort on to make that happen.
 
No error messages pop up. Also, when I reopen the form, I look through all
of the records to see if the record I entered is there. And it isn't.
 
feisty said:
No error messages pop up. Also, when I reopen the form, I look
through all of the records to see if the record I entered is there.
And it isn't.
Click to expand...

If you use the form to delete a record is it gone when you re-open the form or
look at the table? How about changes to existing records?
 
When I delete a record and then reopen the form, the record is gone. Also, I
can change the records that are already in the form, and the changes will be
saved if I reopen the form.
 
feisty said:
When I delete a record and then reopen the form, the record is gone.
Also, I can change the records that are already in the form, and the
changes will be saved if I reopen the form.
Click to expand...

Well you've stumped me. I have never seen this behavior in an Access form. I
would suggest you select your table in the db window and press the auto-form
button to create a quick and dirty new form. Then see if it has the same
behavior. If the new one works perhaps your other one is corrupted.
 
Thanks for your effort in trying to help me. I really do appreciate it!
I'll try your suggestion.
 
Back
Top