I have a problem with getting a form to accept inputs through queries. The
queries are made up of several tables with a mix of text and yes/no check
blocks.
I need some suggestions on how to get the input box to accept the
modifications through the input form.
Can anyone give me some inputs?
John
It's rarely either necessary or appropriate to build a big,
complicated multitable query and then try to enter data into it. Not
all queries are updateable, and when you talk about "several" tables
you're certainly getting into the area where they're not!
Instead, do base your Forms on Queries - but use Forms with Subforms
for one to many relationships; the "one" table bound to the Form, the
"many" table or tables to the subforms. You can (on a limited basis)
include some queries joining "lookup" tables to the table you're
editing, but normally even that isn't necessary; you can instead use
Combo Boxes or other tools to store an ID while displaying a text
value.
If you have a specific example of what's not working, perhaps you
could explain the nature of the data you're trying to update, and
perhaps post the SQL view of the query.
John W. Vinson[MVP]
