records in table will not show up in a form

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

Guest

I am a very new user. I have been entering records in a form with all of the information being saved. Recently, when I enter a new record and then sort alphabetically, the record is "deleted" from the form. After researching I found the six missing records in the main table, but cannot view them in the form. I can make changes to existing records, but cannot add new ones and view from the form. Any and all help is appreciated!
Thanks!
 
I am a very new user. I have been entering records in a form with all of the information being saved. Recently, when I enter a new record and then sort alphabetically, the record is "deleted" from the form. After researching I found the six missing records in the main table, but cannot view them in the form. I can make changes to existing records, but cannot add new ones and view from the form. Any and all help is appreciated!
Thanks!
Click to expand...

Check to make sure that the AllowAdditions property of the Form is set
to Yes. What's the recordsource for the form? Have you perhaps set a
Filter to limit which records are displayed? To see, look at the
funnel icon in the toolbar - if it's not greyed out, click it to clear
the filter.
 
Thanks for responding. I checked the AllowAdditions property and it is set to yes, and there are no filters on the form. The record source of the form is the main table. The above suggestions did not change anything. Any more???
 
Hi,

You might be better off to simply click the table in the Table tab of the
Database Window and then click the Autoform icon. Answer the questions and
allow the form to finish. Try using that form to look at the data in your
table. If it works, start looking at the differences in the properties
between the new form and the one you now have. If it doesn't work or if
you're still having troubles, post back.

HTH
--
-Larry-
--

momie007 said:
Thanks for responding. I checked the AllowAdditions property and it is
Click to expand...
set to yes, and there are no filters on the form. The record source of the
form is the main table. The above suggestions did not change anything. Any
more???of the information being saved. Recently, when I enter a new record and
then sort alphabetically, the record is "deleted" from the form. After
researching I found the six missing records in the main table, but cannot
view them in the form. I can make changes to existing records, but cannot
add new ones and view from the form. Any and all help is appreciated!
 
Thanks for responding. I checked the AllowAdditions property and it is set to yes, and there are no filters on the form. The record source of the form is the main table. The above suggestions did not change anything. Any more???
Click to expand...

If you close and reopen the form is the information there? I doubt
that this is likely, but - is there any VBA code (Events) attached to
the form? (To find out, open the form in design view and click the
"code" icon). Possibly the database is corrupted. I have never seen
this symptom when there isn't some specific thing (such as
AllowAdditions) blocking data entry!
 
Back
Top