When I made a query, first only records with entries in all of the related tables where showing. I was able to change this behavior by changing the join properties (to a left join).
I want the same behavior for the form: all of the records should be accessible through the form. However, I don't find a way to change the join-type for forms.
How can this be done?
In your query designer, double click the line that represents the join, it should give you a button called Join Type or something of the sort. That'll give you 3 options which are basically INNER, LEFT and RIGHT
To make the form have the same records showing, change the RecordSource in the forms properties to change the name of the record from the table to the query with the right join.
