Question about a table and associated form

[Mythblstr]

I am using Access 2007 and I just updated a table with a new record and the record isn't showing up in an associated form. Can anyone give me any suggestion on how to troubleshoot this??

Any suggestions would be appreciated...

 

[boblarson]

How did you add the record

How did you check the form? Did you enter the record via the form, or was the form opened at the time? What is the form's recordsource?

 

[Mythblstr]

The table is the original recordsources of the form. I have 2 other tables that are record sources also. Each table is related to the original table with a primary key. I added the record directly to the original table and gave it a new primary key ID but it never showed up in the form. Also the the record is not showing up in the other tables either even though the other tables have accepted the primary key when I attempted to add the record directly to the other tables! I am actually not certain if the form was open when I added the record, but I think the form was closed when I added the record to the table.

 

[boblarson]

When you say

I have 2 other tables that are record sources also

what do you mean? A form can have only one recordsource. It can be made up of a query that links several tables together (as long as a one-to-one relationship exists and a valid primary key and foreign keys exist).

 

[Mythblstr]

I orignally created 3 tables. When I created the form in layout and Design view when I clicked on "Add Existing Fields" all of the fields from all three tables were available. I think that might be what is causing the problems

 

[boblarson]

That could be. Your structure might not support the form. Hard to tell without actually seeing it.

 

[Mythblstr]

Boblarson, that you for your input, I just wanted to tell you, I live in Vero Beach Florida and one of my goals in life is to move to Portland