Queries and Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
My query appears to be updatable. I can execute it, but that does not change
the appearance of my form.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value error in a Subform 0
Build search function in to a form 5
Can't create a report from my query in Access 1
InputBox within a query 4
Run Update Query From Form 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Problem with Combo box on form 1
Problem with jet database 3

Back
Top