One record will not show up on one form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several records. A piece of each record is parsed to several tables
tied together by an common acct#. I have several forms each based on their
own query. All the records populate all the forms as they should BUT one
record will populate all the forms but one. I am guessing this record has an
issue with the query of that form, but why? None of the other records have an
issue with that query. I have reentered the primary number/ acct# just to be
sure but I still have a problem. Can anyone help me figure one out why this
one record out of many similar records will not populate this one form?
 
Thank you Mr. Browne: I am not sure that will solve my problem because I have
messed with the joins on the various tables and most of the time of the time
I get an error message telling me the querry will not work any other way but
the way I currently have it wired. I will mess with the Null thing a little
later this morning.

What has me puzzeled it all the other records work and they seem to be
filled out the same. Thanks for your input and I will visit your site for
other information too. It looks very interesting.
 
Back
Top