Data Entry Tble

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

when i am running a query so that i can base a form off of it, do i need to
have all the data inputted into the tbles prior to running the query or using
that query to create the form?
 
If you use the Wizard to create a form based on your query, it doesn't matter
what data is in the tables... it will just use the fields you have indicated
in the query (unless you clear the Show checkbox). You should run your query
and make sure it works OK before basing a form on it, because some queries
get complicated and may not let you insert data in the forms/tables if a join
is not setup properly. It's common for a startup project to do table, query,
relationship and form/report design with little data in them and make sure
things work before bringing or inserting data in them.
 
when i am running a query so that i can base a form off of it, do i need to
have all the data inputted into the tbles prior to running the query or using
that query to create the form?
Click to expand...

First off... you don't need to "run" the query at all. If you use a Query as
the Recordsource for a form, simply opening the form will display whatever
records currently exist in the tables upon which the query is based (filtered
of course by the query's criteria); for many queries, you can use the form to
enter data into the query (and thereby into the table).

When the database is in production, you'll never need to even SEE the table or
query datasheets, or the table or query windows; you can do everything through
your Forms.
 
Back
Top