Despite visible setting, form view is blank of all controls that.

[Guest]

Trying to build a data input form based on multiple tables, record source is
set by query builder and correct feilds show up in the field list. The
controls show up in the design veiw and are manipulatable as usual. However,
when go to design veiw , nothing, no feilds, no controls. The property sheet
for the controls and details are set to visible yes and display always. Any
ideas would be helpful. Thanks.

 

[Rick Brandt]

Trying to build a data input form based on multiple tables, record source is
set by query builder and correct feilds show up in the field list. The
controls show up in the design veiw and are manipulatable as usual. However,
when go to design veiw , nothing, no feilds, no controls. The property sheet
for the controls and details are set to visible yes and display always. Any
ideas would be helpful. Thanks.

Common problem for newcomers to Access. The problem is that multi-table queries
are often not editable. In some database systems they are NEVER editable.

It is expected behavior for a form's detail section to appear completely blank
when it's RecordSource has both no current records and no ability to add new
ones. If your multi-table query is read only and returns zero rows then that
will have to be corrected.

In general practice multi-table queries are only for reporting or other data
processing tasks and even when they are editable it can be a bad idea to use
them for forms. Better is to use forms and subforms each bound to a single
table.

 

[John Vinson]

Trying to build a data input form based on multiple tables, record source is
set by query builder and correct feilds show up in the field list.

Well... normally you do NOT want to create One Great Master Query with
all tables and all fields. It's very likely to cause this problem, and
to not be updateable. Instead, consider using a Form for the "master"
or "One Side" table, with one or more Subforms for the related tables.

The controls show up in the design veiw and are manipulatable as usual. However,
when go to design veiw , nothing, no feilds, no controls. The property sheet
for the controls and details are set to visible yes and display always. Any
ideas would be helpful. Thanks.

I presume you mean from design view to form view? This indicates that
a) the Form's Recordsource returns no records - i.e. your Great Master
Query has some inner joins so that there are no records returned; and
b) that the Recordsource is not updateable. You don't see any existing
records because there aren't any returned by the query, and you don't
see the empty new record either because the query doesn't let you add
a new record! Access (rather confusingly) just shows you a blank white
box in this circumstance.

If you have good reason to want to do this all in one query, please
post the SQL of the query - and explain why!

John W. Vinson[MVP]