Dupatt said:
How can I enter data into my tables through a form bound to a query?
There must be a way but it eludes me if there is. I am fairly new at
this so lots of things baffle me at this point. Please help. Pat
--
What you ask is actually the normal way that ms-access works.
The process would be:
use query builder, build your query.
Then, use the form wizard, and use your query as the data source.
That should get you a form based on your query.
The above is a nutshell summary, but much how it works.
if your query is to involves more then one table, then of course we have to
approaching things different, but lets take this one step at a time.
Try building your query, and then save it.
You should try opening the query, try editing some data in the datasheet
mode to ensure that your query is ok, and works the way you want.
Then, try the forms wizard, and supply that query you made.
If you are brand new to ms-access, you should get a book, or do some
reading. It bit harder then word, or excel to get up to speed with...
If you table involves one main reocrd, and then additnoal "many" child
reocrds, then don't use a query, but use a sub-form for the child reocrds.
