form null value fields

[Guest]

Hello,

ive designed a form which collects data from multiple queries & tables using
a unique parameter to fitch records. the form does not display anything if
the record im looking for does not have a linked record in any of the queries
or tables related to my main table. i know this is an outer join issue and i
changed my relationships to diplay all records from the main table and only
thse which match from the other tables but still nothing appears when i look
for a record without a matching value in the linked tables. i just want the
form to display that record and have the related fields to be shown as null.

Any help appreciated.

 

[Allen Browne]

If the query is not updatable, it will not have any no new record row at the
bottom. Therefore there will be nothing to show in the form when the query
returns no records, and the entire Detail section of the form goes
completely blank.

If you expect the query to return records by using outer joins, you will
have to specifically accept Nulls in any criteria on fields on the outer
side of the join.

These links may help:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html
or:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html