New table fields not fully popultaed in their query's correspondin

[Joe M]

Access 2003. I just added several fields to table and added these fields to
the query. The problem is that even though all of the records still populated
over to the query but only some (very few) of these records had this new
field data populated with the query. I verified that the new fields and the
data is in the table. I verified the query is correctly referring to the new
fields. But the query only pulled a little of the data? Suggestions on
troubleshooting?

 

[Pete D.]

If you run the query standalone you can see all the data? Then when you run
the form many are missing, is this correct?

 

[Joe M]

This is correct.

If you run the query standalone you can see all the data? Then when you run
the form many are missing, is this correct?

 

[Pete D.]

Sounds like your form field don't match the format of the data in the query.
Check the form right click on them and check the properties. Suspect your
only seeing data in the field that matches the data type of the form display
field. Also double check the form field filters and such.