Records on Form don't get saved

  • Thread starter Thread starter linda
  • Start date Start date
L

linda

I'm new to access and was wondering if anyone knew how I could input data on
a form...close the form (clicking saving) and later going back and viewing
the data? I did those steps but when I go back the data isn't there...it
goes back to showing 1 record and it being a blank form
 
Access, by default, save data entered when a form is close or when you
navigate to another records.

A couple possibilities are possible with your situation.

1- when you open the form, can you use navigation buttons at the bottom of
the form to goto other records? If so, can you find the previously made
entry?

2- open the form in design view. goto the data tab. Is the Data Entry
property set to True or False? If it is set to True, then the form will
always open on a blank record to allow data entry.

3- Once again in design view, on the data tab, Is there a record source
specified for the form? If the form isn't linked to a table/query then the
data cannot be saved unless it is done programatically through the use of a
save button. If this is the case then you'd need to post the code.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com
If this post was helpful, please rate it by using the vote buttons.
 
It sounds like the Data Entry property is set to Yes.
If this is the case the form can only be use to enter data and not to view.
Solution is to create another form with Data Entry property is set to No or
chage it on the current one.
 
Access, by default, save data entered when a form is close or when you
navigate to another records.

A couple possibilities are possible with your situation.

1- when you open the form, can you use navigation buttons at the bottom of
the form to goto other records?  If so, can you find the previously made
entry?

2- open the form in design view.  goto the data tab.  Is the Data Entry
property set to True or False?  If it is set to True, then the form will
always open on a blank record to allow data entry.

3- Once again in design view, on the data tab, Is there a record source
specified for the form?  If the form isn't linked to a table/query then the
data cannot be saved unless it is done programatically through the use of a
save button.  If this is the case then you'd need to post the code.
--
Hope this helps,

Daniel Pineaulthttp://www.cardaconsultants.com
If this post was helpful, please rate it by using the vote buttons.





- Show quoted text -
Click to expand...

Expansion on # 2

If the value is true, change it to False and it will open at the top
of the table and you can see the other records, When you go to the
bottom you can still add a record as long as the next property (Allow
Adds) is also true.

If you are calling the form from a default menu, change the way it is
called to "Edit" instead of "Add" or create another button to open the
form in edit mode instead of the add mode.

Ron
 
Back
Top