Records not showing up in form

[access-user]

hello all, I'm using Access07. I have a form that is linked to various tables. I imported the data with 116 records. I've since added to a specific table through the form. But not all the records are showing up on the form (I have 130 now) and only 116 show up. No filters are on. Can someone help?

 

[SOS]

Is the data there when you look at the table? Perhaps the ID field or something isn't getting populated.

 

[Mr. B]

You cannot have one form linked directly to multiple tables. You can create a query in which you link various tables using linkable type data to show related information form all tables and then use that query as the record source for your form.

You should be aware that just because you can link the data fom multiple table in one query and then display all that data in one form, that does not mean that you will be able to edit the data. If there are any one-to-many relationships you will not be able to edit the data.

Take a look at using subforms.

 

[access-user]

The new data I enter through the form is going into the table correctly. The ID field is the primary key. All the relationships are there. Plus, when I reopen my database, it stays at 116 records even though I've added more.

I've tried recreated it manually and through the wizard. It seems to work up correctly (with all records showing up) until I add subforms/enter fields from other tables.

 

[SOS]

Well, it might be that you'll need to upload a copy of the database so we can see what is actually going on.