subform only display some query results but leave some fields blank

[susant]

Good evening everyone,

I have a subform that is an update form. The form is based on a query. The query has a parameter field, the parameter field gets value from one of the hiding field in the main form. My problem is that there are only eight out of ten field in the subform display the query results, two of them don't. I can tell there are ten values return from the query, but only eight of them are displayed on the subform fields, two fields don't have a value. If I supply the parameter and run the subform manually, all the return values would display on the form. I could not find out why these two fields don't display the return values. Can someone give me some ideas. Thank you very much in advance.

[June7]

Suggest you provide db for analysis. Follow instructions at bottom of my post.