在表单上显示查询中的所有记录 [英] Display all records from query on form

问题描述

查询时，首先仅在显示的所有相关表中包含条目的记录.我可以通过更改连接属性(更改为左连接)来更改此行为.

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.

这怎么办?

推荐答案

在查询设计器中，双击代表联接的行，它应为您提供一个名为联接类型"或类似名称的按钮.这将为您提供3种选择，基本上是INNER，LEFT和RIGHT

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

要使表单具有相同的记录显示，请在表单属性中更改RecordSource，以将记录的名称从表更改为具有正确联接的查询.

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.

这篇关于在表单上显示查询中的所有记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！