Queries and Forms

M

M_Willson

Can an Input Form be designed from a query?

In an attempt to organize all of the content in a multi-table, multi-topic
database, I attempted to make an input form whee the fields are controlled by
a query. However, when viewing the form in "form view", the fields do not
appear.

Thanks a lot.
 
S

Sharkbyte

Could you expand on your explanation of what you mean by "Input Form", and
how you are trying to control the fields from a query?

I need more information, to be sure, but it sounds like you might need to
create a "lookup-form" to get the data to generate your Input Form. But I
will await your answers, to provide clarification.

Sharkbyte
 
M

M_Willson

When I made a New Form, I seleted a query I made as the source for that new
form. I dragged the needed fields from the query into my form in design view.

I shouldbe clear that NOTHING is displayed in Form View, not even the labels
of the fields. I am beginning to think that this is the wrong approach for
this.

I appreciatre the help Sharybyte.
 
M

M_Willson

My query appears to be updatable. I can execute it, but that does not change
the appearance of my form.
 
S

Sharkbyte

Are you getting data when you view the query, from Detail View? Generally,
you see a blank form (when a form is built from a query) when the query
returns Null.

Sharkbyte
 
Top