is it necessary to create form for query

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

Guest

is it necessary to create form for query or it enough if we create form for
table and report only or just create form for table to insert data and all
the data can fulfill my query and report.Hope respond from others.
 
Zila,

A form's RecordSource can be a table or a query. A query is used when it's
desirable to *display* meaningful information from another table on screen.
For example, in an Order Entry form, you might base the form on a query
linking the Orders table to the Customer table so that you can display the
address, phone number, etc. on the screen once the customer id number has
been entered. Even though it *displays*, the only data saved to the Orders
table is the customer id number.

If you have no need to display information in this way, base your form on
the table directly. If a report needs information from a related table, base
it on a query linked by the related field, and selecting all of the fields
you need.

Hope that helps.
Sprinks
 
thank you very much for your respond. l will try it later after l finish
create all my queries.
 
Back
Top