Form update tables

[Caitlyn]

I've created a form in Access 2007 with information from two tables (Parts
Ordered and PO). Data has been entered into the form; however, some data
does not appear in one of the tables ( Parts ordered). There are about 100
records out of 415 that have not been updated in one table (Parts ordered),
but the information appears in the other table (PO) that the form is related
to. The information does appear int the parts ordered list for the field
that is linked to the PO table. Any ideas what I can do? I'm very new to
access and have no idea what is going on.

Caitlyn

 

[John W. Vinson]

I've created a form in Access 2007 with information from two tables (Parts
Ordered and PO). Data has been entered into the form; however, some data
does not appear in one of the tables ( Parts ordered). There are about 100
records out of 415 that have not been updated in one table (Parts ordered),
but the information appears in the other table (PO) that the form is related
to. The information does appear int the parts ordered list for the field
that is linked to the PO table. Any ideas what I can do? I'm very new to
access and have no idea what is going on.

Caitlyn

What is the actual recordsource of the Form? Please open it in SQL view and
post the SQL text here.

Normally an application such as this will have THREE tables not two - Parts,
Orders (POs), and OrderDetails (or PartsOrdered), with a one to many
relationship to each of the other two tables; and normally one would use a
Form based on the PO table with a Subform based on the third table.

My guess is that you're looking at a query joining the two tables and there is
some sort of mismatch, but it's hard to be sure based on your post.

 

[Caitlyn]

--
Caitlyn

What is the actual recordsource of the Form? Please open it in SQL view and
post the SQL text here.

Normally an application such as this will have THREE tables not two - Parts,
Orders (POs), and OrderDetails (or PartsOrdered), with a one to many
relationship to each of the other two tables; and normally one would use a
Form based on the PO table with a Subform based on the third table.

My guess is that you're looking at a query joining the two tables and there is
some sort of mismatch, but it's hard to be sure based on your post.

I'm not sure how to view in SQL view.
Caitlyn

 

[John W. Vinson]

I'm not sure how to view in SQL view.

Open the Form in design view. View its Properties. On the Data tab pick the
Recordsource property (the first row usually); click the ... icon by it and
accept Access' offer to open it as a query. Select View... SQL from the menu.
Copy and paste the SQL text here.